Why do you need to move Model?

Well,

How do you submit an SQL Server query that queries "if SQL is running " if SQL server is not running for the first place and you can not run queries!

I...

I would not recommend storing multiple types in one field. Normally the application retrieves the locale of the computer and based on this locale settings modifies data for input or...

1. For SQL Logins: on the test /development servers create logins that have the same SIDs as on the production. Use SID instead of UID for your user table.

OR

2. When...

Cory,

I had THE SAME problem when connecting by Openrowset to several servers from any of my SQL 2000 servers. Connection to some servers was successful and when connecting to other...

I had this very problem in 2004 and I have steps to reproduce it. Read below. I even reproduced the problem without any SA just with any sysadmin login. The bottom...

Both replies from Luke and Bill are technically correct if you would be talking about the same job on a regular basis. As I understand your post, this is not...

There are several tools that can help you:

1. SQL Server 2005 Service Broker

2. Microsoft Biztalk Server

3. Distributed Transaction Coordinator that helps with linked servers, OPENROWSETs, updatable distributed views etc....

I would check the security log on the server where the backups are supposed to go. It will show who is trying to access your share. You run your Management...

SQLRep,

did you put the name of your SMTP server instead of words 'put your SMTP server here' in Neil's script?  This message is coming up when the script can not...

I don't know how to do it in Reporting Services. I can suggest the workaround as outputting this report on the disk, renaming it by running a DOS or VBscript...

I use VBscript with Named Arguments where I pass the configuration file name. This configuration files contains 4 lines: TOaddresses, SubjectText, BodyText and Attachments. We do have to have 1...

In addition to the correct answer should not be AWE or 3GB switch enabled in order for one of the instances to use 4GB of memory? I know that in...

I think a good solution may be a client network utility entry. Create an entry for your development server with the common name for 2 servers like MyCurrentServer. Create  linked...

Openrowset is somewhat using DTC (Distributed Transaction Coordinator). Try to go to the Control Panel->Administrative Tools->Component Services -> Computers ->My Computer. Right-Click on My Computer (in Component Services) go to...