Developer Newsgroups: SQL Server Tools

ASP script to display database structure?

Noozer - 6 May 2006 5:01 PM - 2 messages

Does anyone have an ASP script that I can use to dump the structure of an MS SQL 2000 database? The firewall here won't allow any remote connections through and the DB host does not have any web administrations? ...

SQL Mail

20302807 - 5 May 2006 8:23 AM - 2 messages

Hi i'm running sql 2000 and when i'm trying to start the sql Mail its gives me this error xp_test_mapi_profile: Either there is no default mail client or current mail client cannot fullfill the messaging request.Please run microsoft outlook and set it as a default mail client. ...

Can not backup or restore SQL server

jeffzhang44@gmail.com - 4 May 2006 7:46 PM - 4 messages

The sql server was working fine. Since yesterday, can not back up or restore at all. Error message is: Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.) ...

Transfer Logins

MBSNewbie - 4 May 2006 3:50 PM - 2 messages

Hi All, I'm trying to Add a DTS Package to Transfer Logins from My Production Environment to My Test Environment. It keeps erroring out without a reason. I'm thinking it's because users are logged into production. Is there a ...

Spring sale: 25% discount on all Upscene products!

Martijn Tonies - 4 May 2006 1:40 PM - 1 message

Upscene Productions announces a Spring Sale with 25% discount on all database developer tools! Currently available from Upscene Productions: Database Workbench A multi-database engine development IDE, currently supporting Microsoft SQL Server, Oracle, InterBase, Firebird, MySQL and NexusDB. IB LogManager Suite ...

Copying a database with the "Copy Database Wizard"

Jerry J - 4 May 2006 1:16 PM - 2 messages

I am using the Copy Database wizard to copy an SQL 2000 database to a 2005 database on another server. When I get to the "Schedule the Package" wizard and click "Next>" I get an error that says "Proxy account has to be selected ...

Trying to get Mgmt Studio to work as expected

Marc Scheuner - 4 May 2006 6:24 AM - 6 messages

Folks, When I launch SQL Server 2005's Management Studio from the command line, specifying server and database I want to work with, I find it extremely irritating that the Object Browser doesn't also connect to that server using ...

Re: passing parameters to osql

DosItHelp - 4 May 2006 4:36 AM - 1 message

Yes you can! Via temp table using -q and -i option at the same time. Described here:[link] Hope this helps somebody! -- DosItHelp ------------------------------------------------------------------------ DosItHelp's Profile: [link] View this thread: [link] ...

Converting Database Compatability...

Ademar - 3 May 2006 4:56 PM - 4 messages

From 70 to 80 or 90. Any right-ups on this? A single document perhaps? I'm wondering what would be any possible implications in converting my database to 80 or 90. Thanks, Ademar. ...

Compare and Scripting Tools

paul.m.henderson@gmail.com - 3 May 2006 3:30 PM - 4 messages

Hi, We're currently in market for a tool that will allow us to compare and create a script that will synchronize two databases. I've evaluated several options (DBGhost, Red-Gate, ApexSQL, SQL Delta) and was hoping to get some feedback from the forum. Has anyone used any of these? ...

Management Studio: How do I get rid of this Connect to Server dialog on Startup?

Joseph Geretz - 3 May 2006 4:36 AM - 3 messages

What do I need this dialog for anyway? I'm using my Windows credentials to connect so it should happen automatically. In fact, if I cancel the dialog, and then click on any of my connections defined under Registered Servers, I ...

Maintenance Plan on SQL2005

Ademar - 2 May 2006 12:35 AM - 15 messages

I setup a maintenance plan using the Wizard but it doesn't allow me to choose any databases to backup other than the default ones (master, model, msdb, tempdb). Please advise. Thanks, Ademar. ...

Using dtsrun in stored procedure

tyrus - 1 May 2006 7:23 PM - 6 messages

I made this sp CREATE PROCEDURE [dbo].[spTableLoad] AS Declare @Command varchar(1000) SET @Command = 'DTSrun ~/S "local" ~/R "GPIntegration" ~/U "user" ~/P "mypasswrd" ~/N "Import into TABLE1"' exec master.dbo.xp_cmdshell @Command GO but when I run it I get ...

HELP! - SQL Mail

segis bata - 1 May 2006 4:52 PM - 2 messages

Hello every1, My question to you all is why can't I see the SQL Mail icon in the Support Services folder in my SQL Server? how (if possible) do I make that icon appear? Currently I'm running SQL Server 2000 in Windows XP Professional ...

"Export data" problems

Martijn Saly - 1 May 2006 2:06 AM - 4 messages

My experience on copying a database. It seems so simple: - Expanding the "server name" combobox takes waaaay too long, and it still shows no-longer-existing servers, while it forgets whatever existing server I ever typed in there. Next step... ...