Developer Newsgroups: SQL Server Tools

Gen scripts

VJ - 28 Apr 2006 9:24 PM - 2 messages

Hello Is there a way to use the Generate Script option, generate SQL for DB, but not with all the comments it puts.. I am trying to use this SQL, to store it in file then use the file from the program to manually create my DB.... the ...

Profiler: Seven words you can never use in a script?

kevin - 28 Apr 2006 2:23 PM - 3 messages

using Sql Server 2K... I have no idea if there are only seven, but apparently one of Profiler's list of banned words is 'encryption'. profiler displays the following message when it encounters a sp with the word 'encryption' in the text of the object. It is within a comment block. ...

Convert text plan to graphical?

Mike Jansen - 28 Apr 2006 2:12 PM - 5 messages

Does anyone know of a utility that you can copy and paste a text version of an execution plan or even the BinaryData column from Profiler and recreate the graphical execution plan? Being able to capture the plan in profiler is good, but a graphical ...

Weird behavior with performance

willem - 28 Apr 2006 9:26 AM - 4 messages

don't know if this is a bug or an undocumented feature but i installed SQL 2005 on a server in our network. i wrote some php pages to connect and get the data. I track the time what time i costs to execute to query through php. ...

SSMA produces empty functions !?!

northof40 - 28 Apr 2006 8:16 AM - 3 messages

Hi - i'm using the SQL Server Migration Assistant (SSMA) tool to migrate an Oracle 10 database to a SQL Server 2000 database. The reports show that a 100% conversion is possible but the SQL produced has only 'stubs' for all functions and all procedures. For ...

Need a job in DC? SQL Dev wanted.

daniel_hogsed - 28 Apr 2006 1:56 AM - 5 messages

I am helping a friend fill a job for an SQL developer in the DC Metro area. Must have active TS clearance, pay and benifits are OUTSTANDING, start immediatly. Email daniel_hog***@hotmail.com ...

64bit Management Studio

Gigabytetech - 27 Apr 2006 9:48 PM - 4 messages

Does anyone know if it is possible to install management studio for x64 edition on XP 32bit? (without also getting x86 media) ...

Starting SQL Server Management Studio slows ASP .NET page execution

ubator - 27 Apr 2006 4:13 PM - 2 messages

Hi! I'm using Visual Studio 2005 + MSSQL Developer edition 2005 (SP1) + WinXP (SP2). I'm experiencing this major problem. Whenever SQL Server Management Studio (SSMS) is started, the execution of ASP .NET application drastically slows down. Nornally the app takes less than a second to present any information. ...

Taskpad Error

Max Yaffe - 27 Apr 2006 4:05 PM - 1 message

FYI I left a message a few months back about errors in the Taskpad in Enterprise Manager. No fix was found at that time but I can now report a fix. A similar error was seen executing a java script in a help file. My ...

MS SQL administration guide for newbie?

Noozer - 27 Apr 2006 2:18 PM - 1 message

I'm looking for a simple MS SQL administration guide for myself. I'm not looking to learn SQL, just how to move databases between computers, document tables, manage permissions etc... for a local server, or a remote server to ...

SQL 2005 Agent Configuration Problems

Aaron M. Lowe - 27 Apr 2006 1:10 PM - 1 message

Hello, I've got two problems when attempting to set up SQL Server 2005 Agent. Any help on either of these would be greatly appreciated. 1.) When I go into properties of SQL Server Agent and then to history. I ...

Promotional Version Legal?

M Pursley - 26 Apr 2006 3:55 PM - 4 messages

I have a promotional set of three microsoft titles of software (Ready to Launch) which were handed out at a Microsoft event. One of these is MS SQL Server 2005 Standard with 1 CAL. I don't find anything in the EULA, ...

Sql 2005 Profiler

jvcoach23 - 26 Apr 2006 12:54 PM - 7 messages

Iâ€™ve been doing some time test between Sql 2000 sp3a and Sql 2005. Test Database Server = Server 1 Itâ€™s a dual 1800 AMD, 2 Gig or RAM Sql 2000 on the default instance Sql 2005 running on another instance ...

Export the results from a view to a .csv from the command line

SecAnalyst - 26 Apr 2006 7:48 AM - 5 messages

I currently have a view setup in SQL2005 and I need the results from this view exported to a .csv file. (The view draws information from four tables within a single DB) In itself this is easy enough however I need this to be done from the ...

SQL Analyzer Tool

Cheri - 25 Apr 2006 2:10 PM - 2 messages

Hi, I just downloaded the SQL Analyzer Tool, created the sqlbpa db, what do i need to do to begin, review the analysis? Thanks! ...

Backing up related databases

gabi - 25 Apr 2006 1:41 PM - 2 messages

I have to backup two related databases in two different SQL servers. I understand that the way to go is to use marked transactions. So my first question is if this is the only way to do it and second is there a way to ...

Tracking db usage?

Linn Kubler - 25 Apr 2006 1:08 PM - 4 messages

Hi, I originally posted this question in the programming group but then it occured to me that this is probably the correct venue. I am trying to create a report from a SQL Server 2000 database. My trouble is that I can't ...

Viewing job logs from multiple sql servers in the same view?

Jonas - 25 Apr 2006 7:04 AM - 1 message

Hi, Is there any way (ofc there is), but i cant find a good way to display the sql server jobs from multiple sql servers in 1 view. What im looking for is not having to browse down to jobs on every server? ...

Microsoft SSMSE - Printing database layout?

Noozer - 24 Apr 2006 11:25 PM - 6 messages

I'm connected to my remote SQL 2000 server using Microsofts SQL Server Management Studio Express. I can't see any way to print out my database table properties. Under Database Diagrams all I have is "Working with SQL Server 2000 Diagrams", ...

sp_configure 'min server memory (MB)' in SQL 2005

Shane C - 24 Apr 2006 5:47 PM - 3 messages

When I try the following: exec sp_configure 'min server memory (MB)' I get the following error: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option 'min server memory (MB)' does not exist, or it may be an advanced option. ...