Developer Newsgroups: SQL Server Tools

Developer Database Snapshots

Tommi - 25 Nov 2005 2:09 AM - 3 messages

I'm developing tool for developers to create snapshots (i.e. backups) from different states of SQL Server databases. Later when required for unit and/or stress testing or code profiling developer could quickly restore database snapshots. This tool is to be very simple and at first only to support SQL Server 2005 ...

Question about BPA

Kenny M. - 24 Nov 2005 9:48 PM - 6 messages

Is it possible to use the Best Practice Analizer on a remote DB? I mean a DB hosted in a hosting company? ...

Problems with Index Tuning

Alessandro Zucchi - 24 Nov 2005 3:21 PM - 3 messages

Hi all, I'm trying to use SQL Profile and Index tuning to tune performance of my database. My Web application use only Stored Procedures. During the "SQL Profile session" I traced "Stored Procedure RPC:Completed" as event. Follow and example of trace: ...

Running the same query on multiple servers

Dilan A - 24 Nov 2005 12:01 AM - 5 messages

Hi, I periodically run the same query on multiple servers. Currently I do this via query analyzer and would like to cut down the time it takes to switch servers. Is there a tool I can configure multiple connections on and run the same ...

Conversion of Beta 2 Databases

SQL Scott - 23 Nov 2005 5:11 PM - 4 messages

How do I convert a Beta2 database to the RTM version? ...

Turn off server state in Management Studio

Allan - 23 Nov 2005 4:05 PM - 6 messages

Hi, Does anyone know how I can prevent Management Studio from connecting to all my "Registered Servers" to populate the server state (running or stopped). In Enterprise Manager it was possible to uncheck the "Display SQL Server state in console" under Properties for each server but I can't find the ...

Property AnsiNullsStatus is not available for UserDefinedFunction...

Rich - 23 Nov 2005 3:11 PM - 7 messages

If you create a table UDF in a SQL 8 database from Server Management Studio, and then attempt to edit it again, you get the following error: Property AnsiNullsStatus is not available for UserDefinedFunction '[dbo].[TF_TEST]'. This property may not exist for this object, or may ...

OSQL.exe question

Marek - 23 Nov 2005 1:45 PM - 5 messages

Is there a way to process multiple SQL scripts in a single transaction using osql.exe ? Ideally, I'd like to be able to start transaction, execute multiple sql scripts and commit transaction when all of them succeeded or rollback when ...

Query Analyzer change default blank query

Offirh - 23 Nov 2005 10:28 AM - 3 messages

Does anyone know of a way to change the default blank query, into some text? I want that every new query window will start with a Select template or so. ...

Replacement for SQL Query Analyser

Chubbly Geezer - 23 Nov 2005 9:32 AM - 6 messages

Does anybody know if there is one in 2005. Sure I can run the sp's but can't see how I can step through them. Thanks ...

Configuring my instance into BPA

Kenny M. - 23 Nov 2005 2:31 AM - 1 message

I just started using BPA and the DB I want to analyze is hosted in a hosting company, I can login well into the server but the BPA shows errors about the others DB hosted in the same server. My question is: ...

Alternative to profiler

Kenny M. - 23 Nov 2005 1:16 AM - 3 messages

I can use the Profiler because my DB is on a Hosting, what alternative do I have to monitor and make tuning to my DB thks ...

2005 Management Studio vs EM

Vern Rabe - 22 Nov 2005 6:36 PM - 1 message

In EM, I could see the members of a Windows group by going through most of the process of creating a new login. After you select a Windows group, the "Members..." button becomes active on the New Login window, allowing you to ...

SQL Profiler 2000

David - 22 Nov 2005 9:35 AM - 2 messages

When i run the SQL Server Profiler 2000 using a non sysadmin fixed role, it state that only sysadmin allow to perform that function. In SQL Server 2005 Profiler, sysadmin allow to grant non sysadmin user to perform the same function via the GRANT ALTER TRACE feature. Is it possible ...

SQL Profiler 2000

David - 22 Nov 2005 9:24 AM - 1 message

When i'm try using a SQL Profiler 2000 with non sysadmin account, is doesn't allow to proceed and give an error message, only sysadmin fixed role allow. The SQL Profiler 2000 only allow sysadmin fixed role to connect to database ...

dts package

wendy elizabeth 26th - 22 Nov 2005 4:23 AM - 1 message

I want to import an excel spreadsheet 2000 into a sql server 2000 database. When I import the columns from the excel spreadsheet, I am not always certain what columns, and how many columns are included in each excel spreadsheet in ...

Question re SQL Server Enterprise Manager

Ross - 22 Nov 2005 3:30 AM - 3 messages

Hi folks Maybe my memory is wrong, but I sem to recall that it was possible to configure Enterprise Manager to automatically open to the last DB that I was using. Also, I seem to recall that this was done via Tools...Options. ...

Documenting Tables and Stored Procs

Pat Brown - 21 Nov 2005 10:15 PM - 2 messages

Looking for suggestions on tools to document both SQL Server and Axapta DB's Preferably freeware as I have very small budget to work with. Also a book or online documentation on best practice database documentation that I could do myself would be nice. ...