Developer Newsgroups: SQL Server Tools

How to generate drop and recreate index script in SQL Management S

Moh - 30 Mar 2007 6:44 PM - 8 messages

I am wondering it was so simple to create the script in SQL2000. How can we generate the a script to drop and recreate the tables and associated indexes in SQL management studio 2005 Thx, ...

sql server2000; TCP/IP vs Named Pipes

Andre Gibson - 30 Mar 2007 6:00 PM - 3 messages

Hello all, My company is running an application that uses sql server 2000 sp3. Sql server 2000 is configured to accept only TCP/IP (port 1433) or Named Pipes. We prefer to use TCP/IP but we are having issues with users losing there ...

Tools to get sql general measures

johnny - 30 Mar 2007 5:32 PM - 1 message

Hi, I like to know if anybody knows about a tool that give me different database's information, statistic information, such as: -how may access are doing it to a determinate SP -how many tables an SP us -what is the table that is more used ...

How to detect whether SMO is installed?

n7dai - 30 Mar 2007 4:46 PM - 3 messages

Hi, folks -- I am working on an install bootstrapper that (among other things) will install Server Management Objects (SQLServer2005_XMO.msi from SQL Server 2005 Feature Pack) iff it's not already installed. So, how to detect programmatically whether or not it's already ...

oSql is adding line-breaks when "-output" or ">" is used to save output to a file.

"A_Michigan_User\ - 30 Mar 2007 2:20 AM - 2 messages

-- No line-wrapping here: PRINT '123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789' PRINT '123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789' PRINT '123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789' I save the above 3 lines to a text-file called: oSqlTest.sql ...

how to find media name of the last successful backup via SMO

ktmd - 29 Mar 2007 7:40 PM - 2 messages

Would you show me how to use SMO to find the name of the media of the last succesful backup via SMO? I use maintenance plan to do backup. I need to find the name of the media (backup file) that was created for the last backup. ...

sp_sidmap on SQL 2005

kzakoski - 29 Mar 2007 3:54 PM - 3 messages

I've been using sp_sidmap to remap users when moving databases from server to server in SQL 2000 without any issues. Now that I'm setting up and migrating to SQL 2005, I've encounter issues with SID's not matching and would like to ...

Generate database script does not include database role members

isyourfriend - 28 Mar 2007 5:26 PM - 4 messages

I have read in the connect website (https://connect.microsoft.com/ SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125021) That this issue was resolved in SP2. I have SP2 installed and still have the same problem. Am I missing something ? -Noel ...

Portable db comparison tool?

Arthur Dent - 28 Mar 2007 5:07 AM - 5 messages

Hi all... I'm wondering if anyone might be able to point me here... i couldnt find anything on google, and hope someone else has come across this... I am trying to find a tool which will allow me to compare two databases to ...

I can't Copy a database from Sql Server 2000 to 2005

Johan Garst - 28 Mar 2007 1:55 AM - 4 messages

Hi, I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy Database option from Management menu. I want to transfer all tables, and all stored procedures. I've tried everything for the past 3 days, and it didn't ...

Connect to a remote database using QA or EM *WITHOUT* ever creating CNU aliases first? (MS SQL 2000

"A_Michigan_User\ - 27 Mar 2007 4:26 AM - 3 messages

Accessing a hosting company's MS SQL 2000 server. I don't have any problems connecting to a remote database with Query Analyzer (QA) or Enterprise Manager (EM)... as long as I first create "aliases" using the "client network utility" (CNU). ...

conversion

Luuk - 26 Mar 2007 8:09 PM - 3 messages

Hi all, I want a good tool to write scripts with to convert data from a MSSQL database to any other database (possibly, but no neccasarily, also MSSQL) Anyone have any good ideas? ...

BE VERY CAREFUL, AS YOU MIGHT BE A VICTIM OF SCAM/FRAUD RIGHT NOW!!

SIS - 26 Mar 2007 10:41 AM - 1 message

<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY><FONT size=2> <P><FONT face="Arial Narrow"><STRONG><IMG ...

BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD!!!

SIS - 26 Mar 2007 3:22 AM - 1 message

Attention! With several on-going cases of fraudulent practices being carried out by criminals on the internet, you are advised to carefully read this circular, so as to completely secure yourself from every fraudulent and scam attacks by criminals on the internet which is very rampant in our current world. ...

Modify default Enterprise Manager font.

Panos Tsapralis - 25 Mar 2007 3:39 PM - 2 messages

I have installed Microsoft SQL Server 2000 along with Service Pack 3 on a system with Microsoft Windows NT, Ver.4.0 (with Service Pack 6a). Everything seems to work fine except that everything in the Enterprise Manager application is displayed in an annoyingly tiny font and I do not ...