SQL Server Tools

Hi When creating a new db in Server Management Studio how can I choose the path of the new db to F:\MyPath instead of the default? Thanks Regards ...

The following code works ... Set objWMIService = GetObject("winmgmts:\\.\root\Microsoft\SqlServer\ComputerManagement") Set colItems = objWMIService.ExecQuery("SELECT * FROM ServerNetworkProtocolProperty WHERE PropertyName = 'TcpPort'",,48) For Each objItem in colItems     objItem.SetStringValue("1433") Next However is a specifiy a named instance like ...

Hi, I've installed  SQL Server 2005 Enterprise Edition w/ SP1.  I setup a maintenance plan using the wizard to backup the databases.  If I run the plan manually it runs fine.  I scheduled the plan to run each night.. ...

I'm doing some work for the clients who have SQL 2005 Small Business versions. I do not see Management Studio installed on their servers. On one of the server I used a free version of Management Studio to attach database I ...

Last night we had a major storm hit us and the power went out. The SQL 2000 server has a UPS on it so should have went down gracefully - but who knows. Anyway, this morning no one was able to get into the data. When I checked ...

Somehow, somewhere, at some point I managed to changed the 'snapping to grid' behaviour of SQL server 2000 diagrams.  When a relationship is moved the line often splits and I can not align it back up perfectly again. All my old diagrams look nice and neet, all the new ones look misaligned. ...

When I try to connect to a Database Engine in SSMS, there is an entry for Network Protocol in the Connection Properties tab.  It has the value <default>.  1.  Which Network Protocol will be used when the value is <default>? ...

I upgraded to sql server 2005 (developer) sp2. I now have Object Explorer Details instead of Summary tab. Object Explorer Details looks in most ways very similar to the Summary tab, however, I do not see the Reports button. Anyone know where it went? ...

Unlike SQL 2000 Query Analyzer, in SQL 2005 Management Studio, it appears that you cannot configure a keyboard shortcut command to trigger a user-defined stored procedure. For example, if I set Ctrl+3 to trigger a system proc such as sp_helptext, ...

Hi, I'm looking for at tool to help me storing Stored Procedures og Table-Definitions in VSS. Can anyone surguest me some tools or articles, that can help me to find a great tool? Karsten Lundgaard ...

I just ran the Vista upgrade advisor and it says the following might have issues: Microsoft SQL Server Setup Support Files (English) Microsoft SQL Server Management Studio Express Both are for SQL Server 2005.  Are there patches available? ...

When I enable "display actual execution plan" and run a query with a "FOR XML" clause, SQL Server management studio hangsup. Very annoying because any changes to SQL query files are lost. ...

I am looking for the summary tab in Management Studio Developer Edition. It is not under the view menu nor does F7 seem to work. I only have Object Explorer Details under the view menu. In the Standard Edition I do see the ...

I am trying to insert a record into a table on a linked Oracle server from Query Analyser. Everything works fine until I add an accented character. For example: INSERT INTO CONDOR_SKYE..CONDOR.BW_LANGUAGE_TRANSLATION VALUES ('QRYELT','YCH_L_1038_ZEUSG_M00','EN','20070208',null,'Verkaufsstellenumsatze') ...

Are there any techniques for locking down features of Management Studio? Nice tool, but its like givng out a loaded gun to low experienced users. ...

GlacierCall me old school, but sometimes I'd like to just print out a SQL Server agent job for review. Is there a built-in feature for this? Does somebody know of an external script, shareware tool, etc. that can do this? ...

I have a problem. My system C:\ was initially setup with 4GB. The C:\Winnt\System32\Logfiles\ folder is over 500MB. I found out that everyday IIS generates a 5MB log file. What is the best way to cut down on log file size? How can I set up SQL ...