Developer Newsgroups: SQL Server Tools

Problem installing sp1

John - 19 Aug 2006 9:51 PM - 4 messages

Hi I downloaded and tried to install the sp1. It went through once completely with 'SQL Server Native Client' left out pending restart. I re-ran the set-up, this time it did the client but on the second item 'Set-up support ...

SQL Profile - Duration value more than Profiler run time

kart - 19 Aug 2006 3:11 PM - 3 messages

Hi All, We monitored the event RPC:Completed in SQL Profiler for a web-service call, which in turn calls an Stored Procedure and the results were strange. The output came very quick, but the duration value was too high. The actual time ...

SQL Server 2005 Management Studio vs. 2000 Enterprise Manager/Query Analyzer

Rob Roberts - 18 Aug 2006 5:38 PM - 11 messages

I really don't like the new SQL Server 2005 Management Studio. I much preferred the old SQL Server 2000 Enterprise Manager and Query Analyser. The thing I hate most about Management Studio is this behavior: If I select ...

SQL Server 2005: Express or Developer?

MC - 18 Aug 2006 5:30 PM - 2 messages

I'm familiar with SQL Server 2000 but not with any of the 2005 editions. My company is switching from a Java/Linux platform to a Microsoft one and I'm building a developer's workstation software configuation. For database tools, does it make any sense to go with ...

How do I - Export Stored Procedures in SQL 2005

Curtis - 18 Aug 2006 4:53 PM - 3 messages

I have recently upgraded to SQL 2005 and have not found a tool for exporting stored procedures from a source server to a destination server. In SQL 2000 this tool was in the export feature and it seem MS has removed the copy ...

Lady Only

SEXBLOG - 18 Aug 2006 4:10 PM - 1 message

Lady only 24-Hrs +91 9810577227 OR email to i***@lenstar.org ...

rastreadores GPS Ratreador gps localizadores bloqueadores 1556763

rastreador gps rastreadores gps de =?ISO-8859-1?Q?Ve=EDculos?= - 18 Aug 2006 1:58 PM - 1 message

CENTRAL ÚNICA DE VENDAS 10 Marcas de ratreadores, Compare e Compre. Rastreador de Veículo Rastreadores de Veículos Rastreador GPS ...

Read

Weman - 18 Aug 2006 1:19 PM - 1 message

Lady only 24-Hrs +91 9810577227 Send email to i***@lenstar.org get access code. ...

SQL Server 2005 x64 Maintenance Plan Creation Fails

Ron - 18 Aug 2006 5:48 AM - 2 messages

I have recently installed SS2005 x64 on a Win2003x64 box. When I try to create a maintenance plan I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has ...

Love Hotline

Beauty - 18 Aug 2006 2:08 AM - 1 message

Lady only 24-Hrs +91 9810577227 ...

how to restore database in SQL 2005

Kamil Skup - 17 Aug 2006 2:37 PM - 3 messages

how to restore database in SQL 2005 ...

Alternative to SQLClean?

Leon Mayne - 17 Aug 2006 12:55 PM - 4 messages

Hello, We need to get a tool to identify all unreferenced objects in our database, for which Apex SQLClean seemed to be perfect, but there is a bug in it which stops it from working in our environment, and it looks like they arn't going ...

SQL Profiler - Strange data in RPC:Completed

kart - 17 Aug 2006 12:40 PM - 4 messages

When we did stress testing, we found a strange behaviour in SQL Profiler. We validated the same after stress test is complete and found similar issues. Here is the detail. Our application is .Net based application, which call webservices (.NET). ...

Sql debugger

New - 17 Aug 2006 5:43 AM - 4 messages

i had read in msdn about sql debugger for debugging of stored procedures and queries. but i am not able to find the sql debugger tools. can anyone give some idea about the same. Thanks. Mitesh ...

SIMPLE command to convert string to number? Not CAST or CONVERT.

dba_222 - 15 Aug 2006 10:11 PM - 6 messages

Dear Experts, Ok, I hate to ask such a seemingly dumb question, but I've already spent far too much time on this. More that I would care to admit. In Sql server, how do I simply change a character into a number?????? ...

ANN: Context Database Designer v.2.09 for MS SQL 2000/2005/Express is now available!

Context Software - 15 Aug 2006 8:00 PM - 1 message

Dear Friends, We are happy to announce the new release of Context Database Designer & Database Extensions v.2.09. Context Database Designer & Extensions now supports: - MS SQL 2000/2005/Express - MS Access (NEW!) - My SQL 4 & 5 ...

Copy Database Fails: .Net runtime error?

geek-y-guy - 15 Aug 2006 2:11 PM - 3 messages

when trying to perform a copy database using SMO, everything works except the final step. This is Win2003r2/sql9.0.1399 I presume this is an error with the ASP.NET user's permissions, but does anyone know what the resolution is? ...

Copy Database Wizard: resolution to "login timeout expired" ?

geek-y-guy - 15 Aug 2006 1:12 PM - 1 message

Hi All: Old server: Win2KAS/SQL2000sp4 (8.0.818 - sa) New server: Win2003R2/SQL2005 (9.0.1399 - sa) Admin: WinXPproSP2, SQL Mgmt Studio Trying to use copy dB wizard and failing at step "configure the package" with: "While trying to find a folder on SQL an OLE DB error was encountered with ...

Cannot edit table data using Enterprise Manager

LBT - 15 Aug 2006 11:29 AM - 6 messages

Hi Experts, I have the problem to edit data of a column contained inside a table directly using MSSQL Enterprise Manager. This is only happen when the length of the data is more than 1000++ characters. Whatever I type into the column ...

import data.

Alex Castillo - 14 Aug 2006 4:41 PM - 3 messages

Hello... I'm trying to import a Sybase SQL Anywhere 5.5 database to MS SQL v2000. When the Import process finishes, it reports some errors, but it does not let me review them. I wonder if is there any log file created by the import process I can use for review? ...

SQL Server trigger that fires only on update of certain field?

dba_222 - 14 Aug 2006 2:01 PM - 3 messages

Dear Experts, I'm an Oracle guy, who is being given more SQL Server assignments lately. I've been looking for things on the web about this, but I can't anything so far. In Oracle, I you can create a trigger on a table that -only- fires if ...

Backing up and restoring remote database to and from a local disk

Peter Croft - 13 Aug 2006 6:10 PM - 3 messages

Hi. I am running Enterprise Manager for SQL Server 2000 on a local server and accessing a database on a remote server. How can I backup the database on the remote server to a disk on my local server, and then restore from the local disk to the remote database later? ...