I agree with sgmunson. Back in the day when I did alot of DTS work, both the truncate table and delete from table would work fine. The syntax...

Hi There,

I wrote a series of articles about alerts last October.

If fact, I wrote an article on testing alerts that has the code you are looking for.

Enjoy

http://craftydba.com/?p=1130

John Miner

Crafty...

I would use the import / export wizard. It creates a very basic SSIS package that can be saved to file. You select a source, you select a...

The precedence contraints are the lines. The maintenance plan is actual an SSIS package under the covers.

There are three types of lines: green (good status), red (bad status),...

Hi All,

Activity monitor will be very slow if there is alot of activity going on. I basically do not use it. Use sp_who2 and look at the database...

Ut oh. Are you drawing a maintenance plan? If so, here are some comments.

1 - Break plans into small pieces since they need to be scheduled at different...

I do not even have SQL Server up and can tell you what the problem is.

If js.command is null, the expression will have issues. If something is not found,...

http://www.sqllion.com/forums/topic/adventureworks-failed-object-initialization

Please check out this post.

There are certain requirements of the adventure works database. One is file stream being enabled and running.

Please try again after verifying the prerequisites...

The TSQL example below work since you are comparing apples with apples.

select * from xyz where year(created_on) < year('2012-01-01')

-- or

select * from xyz where created_on < '2012-01-01'

Have you taken a look at Quest Softwares Toad?

http://www.quest.com/toad/

I first used this tool at least 5 years ago when SQL Plus for Oracle sucked.

The tool has evolved to...

Here is the URL to msdn with details.

http://msdn.microsoft.com/en-us/library/ms178078.aspx

The quickest way is to select the database name in the object explorer in SSMS.

Right Click.

Under the task menu, there is a generate script select.

It will bring up a bunch...

For a particular constraint, locate and select it in the object explorer, SSMS. Right click and select script constraint as drop and create.

Unfortunately, that does it for only one...

Hi Guys,

We finally figured this one out but do not understand why it worked in WIN 2000 but not in WIN 2003.

1 - Keys did not need to be backed...

I love hardware issues. Not really!

Here are some questions that I have for you.

1 - Are you backing up directly to tape?

2 - Is your OS up to date...