Most likely the value in ColName does not reference a valid column name in the destination table. There may be one bad row out of thousands, but it only takes...

Can you confirm that the database is not auto-closing as mbaker mentioned and when you logon are you using windows authentication or SQL Server authentication as jt-75 previously asked? If...

The volume shouldn't be a problem with the solution I provided. I'll try to put the SQL together for you here. Try it out.

-- Get a listing of every month...

Yes and no. If you want to keep different resultset structures you can use a cursor with one select for the month header, one select for the core data, and...

If have to confess my ignorance about not knowing the PFS, GAM, and SGAM acronyms. As for viewing the data, I think what you are after are the DBCC TAB,...

Everything jt said sounds like solid possibilities. Also consider that it could be a networking issue. Most times I've noticed someone post an issue like this in here (I've only...

Calvin, the 3 strings you noticed are 1) a list of X variable declares of 8000 length varchars 2) a list of assignment selects to assign values to each of...

CONVERT( varchar, MyDateColumn, 101 )

If you want it in a datetime field just convert back again. This results in a zero time which is midnight.

CONVERT( datetime, CONVERT( varchar, MyDateColumn, 101...

I've had to deal with this same issue a number of times myself. I finally decided to stop doing it the hard way and wrote these three stored procedures. The...

Using a table var avoids  any recompiles of the proc created by #temp tables.

How does creating a #temp table impose a recompile of the SP? I know that it...

This is a locking problem at the operating system level. Some program (perhaps SQL Server, a file system backup program, or something else) has a file lock on the BACKUP-TERCA-FEIRA.BAK file....

Did you try the NextRecordset as jpipes mentioned? You may have 4 recordsets with one error on each.

Assuming the parameters were kept as variables and not hard coded into the SQL I personally haven't seen any differences between the EXEC of a SP and its content copied directly...

There is a bug in SQL Server (I noticed it in SQL 7 and SQL 2000 SP2 and SP3) that is seen in EM and in QA. Stored Procedures are...

Ahhhhhhhhh.

Denying DataWriter is different than not granting DataWriter. The former will override the implicit SP rights. Simply grant datareader (only if the user needs read access outside of SPs) and...