It's actually sp_cycle_agent_errorlog to cycle the sql agent log if you're on sql 2005.

This should help. This deletes a column and all constraints:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1855

You'll need to modify it to have it do an alter table/alter column command instead of...

The solution I'm using isn't pretty, but it works. Here's what I do:

Create a script of all the stored procedures as "create to" file or clipboard. Once it's...

I did a little more digging, and it looks like bcp can do what you're wanting.

http://msdn2.microsoft.com/en-us/library/ms191232.aspx

This should be a little easier than the method I outlined above.

James

The only thing I can think of is to make a backup of the db, restore it (on the source machine), then remove all the tables EXCEPT the one you...

I don't know about the first 2, but I think I know what's happening for the 3rd one. Look for a statement similar to this:

SELECT a.col1, b.col2

FROM a, b

This...

I've created a full-text index on a table, and I have questions about SQL Server 2000's full-text search component. First, can full-text search look for a suffix (e.g., match the...

The only thing I could recommend is making sure the table has a column of data type "timestamp". It's used by the full text catalog for doing an incremental...