c?

SQL Server 2005 provides a new stored procedure specifically for this:

sp_testlinkedserver [ @servername ] = servername

Returns 0 for success and 1 for failure.

Thanks for the link Phil, but you still have to dig down to the individual event classes and count the events in each class to get a total number of...

I think you have a problem in the trigger because if you are updating department_id in departments you won't have any rows in the employees table with the new department_id...

I also prefer separate procs. Of course with the new MERGE syntax in 2008 that would probably change. Then the name would be usp_MergeCustomer or something that identifies...

I believe that you can return any value other than 0.

I'm not sure what your question is, but in most instances you can use either a CTE or a subquery and similar performance. I have learned to use CTE's...

Sorry pal, but rebuilding it is the only fix now. Then you'll need to redo all your security and re-attach all your databases. I hope you have things...

Have you attempted the fix that is suggested in the thread you reference? I think you can get around it by storing the credentials in the ReportServer database.

Can you post the rdl?

Wayne West (10/1/2008)

---

skjoldtc (10/1/2008)

---

... Where or how would you draw the line? Everyone has a different breaking point. If the boss asked for yet another weekend after you just spent...

You can reset an identity column by running DBCC CheckIdent('table', Reseed, Seed value). I suppose you might be able to put a trigger on the table to reset the...

Input or output columns? You can't modify the input columns, but you should be able to alter output columns.

JMSM (10/1/2008)

---

I think that u don't understand my question.

I've got one user that is dbo on 3 databases, db_datareader on another 3 databases and db_datawriter on more 5 databases.

What i...

"?" is the parameter placeholder for OLEDB.