The attached SP should do the trick...

The best option is to configure the server to use DB Mail. DB Mail is easy to set up and is very reliable. With DB Mail, if your...

I have heard of people playing with SQL Server under Wine, but do not know if everything worked. One thing is definitely certain - if you get SQL Server...

I am one of those people who have said that min memory should always be set a little bit below max memory. This is repeating feedback from PSS who...

This needs to be fixed by your Windows Infrastructure people. All servers in a domain need to have their time synchronised otherwise AD can get very upset. If...

The attached proc will script all your DB roles and their permissions, and your DB users.

Do a Google search on: custom report sql 2005

There is a Taskpad View report on sqlblogcasts, and other reports can be found elsewhere.

The GUID is not a magic bullet. You can do your database design just as well with other data types.

I do recommend you read Colin's post. ...

The FT catalog has been built as much as it can ever be built. The messages are just saying that certain documents could not be included in the catalog.

Can...

This is a dupilcate post. Please answer on http://www.sqlservercentral.com/Forums/Topic433935-146-1.aspx

sp_configure 'xp_cmdshell' is only available in SQL 2005 and above.

In SQL 2000, the best way to disable xp_cmdshell is to modify its permissions in master to prevent use by Public....

This is no help to the original poster, but if anybody else is considering buying Vista then you should consider getting a TechNet subscription instead. It costs about the...

In SQL 2000 you can grant anyone permissions to use the SP_OA routines.

In SQL 2005 and 2008 they can only be run by someone with Sysadmin authority. ...

If it is still relevant, attached is a proc than can script all tables in a DB.

Jared,

Is there anything in your system that changes the recovery model of your database to Simple or Bulk Logged? If this runs between yuor DB backup and your log...