Oh, and another possibility. Check that the query/sp is working with the correct database. Just today my colleague was completely perplexed how it is possible that a view returns different...

Yes, I know that from our company. CV of an author of book, summary of the book, a few pages of text here and there. TEXT is the right datatype...

If your main problem is growth during optimization/maintenance which uses inbuilt functionalities (DBCC DBREINDEX, DBCC INDEXDEFRAG), then it is quite probable that you can't do anything about it. As far...

Hmm.. this system seems pretty illogical to me so I may have problems understanding what should happen when, Anyway, here is one of your problems:

SELECT @LastScoreByTrustier=TrustedScore FROM MemberTrustLog WHERE...

You misunderstood Koji. He was asking whether you have checked the procedure (or the query you tested) to make sure that it does NOT contain this command. In case you...

I'm sorry, but your select list contains references that can't be used in this place... Table f0116sp is not available unless you join it - the derived table is aliased...

The source file (text file you want to import) must be correct. Try working on this angle - make sure that it will not be entered incorrectly. If possible, make...

If you don't have DBA permissions, you should contact someone who has.

Also, you can consider dropping some old tables you don't need, or at least deleting unneeded rows. This could...

Please post more readable code - use table name/alias with each column in the select.

Table structure of involved tables would also be helpful.

At the moment, I can only make a...

Maybe this is just misunderstanding and karthikeyan just wants to TAKE exam and is asking how to learn for it? I seem to remember that he stated about himself a...

Thanks Lynn, good point... we already have one server running SQL2005 and we had to modify the procedure for sending emails. We also use sp_send_dbmail in 2005 instead of SMTP...

Try to Google the messages, or search for it in Microsoft knowledge base. There are some bugs that display this infomessage and can be fixed by installing a newer patch.

Oh,...

Hello,

this probably isn't the best way to format output... maybe you should consider using sp_makewebtask, which will allow you to create a HTML file with table, and then attach the...

Since you want to select something that is NOT in your table (at least I assume you want to select ALL dates between certain boundaries, not only those where there...

Hello,

let me give you the standard link for your situation 🙂 it explains lots of things and gives tips on how to avoid dynamic SQL best (or how to...