In this case it depends how much hardware do you have.

If you have another server with similar configuration, you may keep the second server in synch with the production server...

I answered "correctly" but there actually is no correct answer on the list. Unless in the details row the images can appear ANYWHERE in the report, not only in the Header...

He was asking about another table. There is no 'o' or 'i' in the name and the ID of this object is 42 if you query sysobjects.

select

*...

Use WMI scripts

Sarbanes-Oxley act requirements, Goverment regulations, Security Compliance and more.

I did not hear that we can copy text from TIFF files.

Also, a PDF book of 919 pages for examppe takes about 2 MB, what will be the size...

You have to add this person to DTS roles. Here is my experiment that shows that only User Ids for users or roles 10,11 and 12 have Execute permission on...

El,

Can you use Computer Management to start service on the laptop from the desktop and back? Open Computer Management Console, Action menu ->Connect to Another Computer and see if you...

Matt,

This is a good approach in general, but it may not work if:

1. The application name is not provided in the connection string by the application

2. If all instances are...

I guess that server A has some kind of Firewall and the server B was using TCP/IP to connect. And that port 1433 was open.  Or you were using named Pipes...

I have somewhat similar layout for one of my applications. I have 4 instances of WebLogic with different IPs on the same machine connecting to one SQL Server. The instances connect to...

How do you connect to the server? It is possible that your login does not have rights to start or stop the services when connecting remotely

I tried to create an alert for Create Database based on this script and on BOL but it said:

Msg 22022, Level 16, State 1, Line 0

SQLServerAgent Error: WMI error:...

Hi Debbie,

I am watching the discussion but can not give any input on format file because I did not work much with format files and BCP. The only thing I...

You may replace steps with individual jobs and implement the workflow using stored procedure that you can schedule.