I don't see a sence of creating a stored procedure here. The select statement is short and not complicated, only code ID  is returned so it may or may not...

VBscript: Copy and paste it in the file with extention .vbs Double-click to run.

Works on Windows XP and should on Windows 2003 Server. Not sure if it will work on...

Thanks David. I was of the same opinion. Even if it was a typo and the course materials mean SSIS not DTS you can not create an SSIS package in Object...

Hi,

I do have file copy as a second step to some of my jobs. I don't use xp_cmdshell explicitly. I create a step of Operating System Command type. As a...

I followed BOL and answered "as expected". I do wonder about #17:

"

This is what I have in my records from a while ago. I don't remember the source. I do remember that what I had to do is to follow the...

Martin,

This is OK. You can still use Temp. Table and then use ISNULL or CASE with Stored procedure. There was a discussion some time ago on how to insert the...

I don't know how to configure the user interface, but in your query you can use Case to replace NULL values with an empty string as two single quotes using...

Learn Their Language!

I usually say that I earned my MCSD.NET in addition to my MCDBA only in order to know how exactly them, developers, will corrupt my databases 🙂

Totally agree with what Rudy...

Are these databases on the same server for production? I mean, old and new database? I had cases where the development upgrade with both databases ran on the same machine...

I think that every type of a person can be helpful in any enterprise. It takes a good manager to do that. Let me show you possible examples of how...

Hi,

I had something similar with Dell servers twice when installing SQL Server: on 2 best servers with big hard drives the installation process took 2 hours. It took about 10...

Rudy,

do we have to update the procedure cache after Update Statistics by DBCC FREEPROCCACHE? I tend to do that because I think if we updated statistics then everything has to...

Answering Question 1:

BOL says "To set up pager notification, you must install software on the mail server that processes inbound mail and converts it to a pager message." See "Defining...

Dan,

🙂 Don't be too hard.

I would start with her DBA. It looks like your backup person does not have a lot of DBA skills so I would think a DBA should be...