Developer Newsgroups: SQL Server Tools

Dumping sql server

John - 21 Apr 2007 4:59 PM - 2 messages

Hi Is there a way to dump all the sql server data into some sort of file that can be imported into a local sql server later? I have used sql server dumper but it is not very stable and crashes during sump. ...

couldn't rename or delete maintenance plan in Management Studio

Lynn - 20 Apr 2007 6:08 PM - 3 messages

Hi, I tried to rename and delete one old maintenance plan which is created by other DBA and before the machine was renamed. But, I kept getting the following error. I can rename and delete the maintenance plan I created. ...

SQL 2005 - load generator?

Matthew M (UK) - 20 Apr 2007 4:20 PM - 2 messages

Hi, Could someone tell me if a free load generation/simulator exists for SQL 2005? We are doing some power measurements with Intel E5310s and I would really like to give the processor and disks a bit of a run. ...

scm.exe

John - 18 Apr 2007 10:54 PM - 3 messages

We have a tool based on sql 2000 that uses the scm.exe (Service Control Manager) command line utility to communicate with a service. scm.exe was apparently pulled from SQL2005. What is the equivalent >>command line<< tool? ...

Problems configuring proxy account

Maria Isabel Guzman - 18 Apr 2007 6:49 PM - 4 messages

Hi, at this moment I have a user that is member of sysadmin in a msde. I need to remove this user from this group but the user use the xp_cmdshell. I configured the proxy account on this intance with a user that is ...

SQL Agent Alerts won't use Database Mail profile

Tim Greenwood - 18 Apr 2007 3:38 PM - 2 messages

I've setup myself as an operator and provided an email address. I also setup SQL Agent to use Database Mail and setup an 'Operator Alert' profile just for this purpose and assigned that to SQL Agent. Now when I run a job ...

Good Tool For MYSQL and POSTGRESQL

Karthik Vatsan - 18 Apr 2007 3:10 PM - 2 messages

Hi, Could you guys please suggest some good administration tools to monitor MYSQL and POSTGRESQL as i am a SQL Server DBA and had to recently manage some systems running on POSTGRESQL and MYSQL running in linux. I have never ...

Should I Upgrade from RTM to SP3a or SP4 To Try To Fix Problems?

Dave - 17 Apr 2007 6:04 PM - 9 messages

I am running one Windows 2000 Server with Microsoft SQL Server 2000 RTM and one Windows 2003 Server with Microsoft SQL Server 2000 RTM currently and have not had any problems with viruses or applications or databases created for years. ...

Database Mail SMTP

Jason - 17 Apr 2007 5:18 PM - 2 messages

I am looking to setup database mail in SQL2k5. A requirement is that we receive confirmation messages when the email is sent via smtp. How do I configure this? ...

Scripting Performance after SP2 applied?

Chuck Urwiler - 17 Apr 2007 2:52 PM - 12 messages

Hi there, I have applied SP2 to my development machine, and am at build 3054. Prior to SP2, I was able to generate a script rather quickly for my databases. However, since SP2 was applied, it is excruciatingly slow, something on the order of 10-15 seconds per table. ...

Major SQL Server 2k5 x64 configuration problem

Nick - 17 Apr 2007 9:54 AM - 4 messages

Dear All, I've just installed two brand new SQL Server servers with Windows 2003 Server 2003 R2 + SP2 and SQL Server 2005 Standard Edition + SP2. I now need to configure the network protocols for SQL Server on these machines, but on both machines the SQL Server instances are not showing up in ...

SQLMaint.exe Utility

Saravanan - 16 Apr 2007 8:20 PM - 1 message

Hello All, I am using the sqlmaint utility to backup my database and transaction log. I am using the DelHtmlRpt option and the DelHtmlRpt option to generate HTML report and trying to delete reports that are older than 7 days. Below is part ...

SQL Job Question.

Morgan - 16 Apr 2007 7:12 PM - 4 messages

Hello to all, I want to ask something according my MS-SQL 2000 sp4 if u can help me. I want to make a job that automatically every day restores a .bak file of a database to another database. ...

Does Visio support sp_bindrule and sp_binddefault?

ksturgeon - 16 Apr 2007 3:14 PM - 1 message

I've reverse engineered a database using Visio for Enterprise Architects (2003) and see that instead of using sp_bindrule or sp_binddefault it actually attempts to create the rule or default on every colum to which it should be bound. For instance, the following script was generated by Visio... ...