Updatetext should be the answer as .WRITE will not work on the TEXT column!

Thanks for the great tip!!!

Good question!

I looked for the text of the queries returning DBID as NULL in my environment and found that select statements using openquery to get data from remote server...

SUM(DISTINCT PROMO_DISC_AMT) is not the right solution if PROMO_DISC_CODE can be repeated in the data (which I guess must be a possibility).

If your data looks like :

INSERT INTO @FACTORDER

SELECT 4,...

Thanks for the quick response!

Using Left Outer Join solved the problem.

So, in which situation would you use count(1) instead of a count(*)? Or is it even a good practice to use count(1)??

To me it seems that they are essentially doing...

Good Question!

Could somebody please explain the difference between count(*) and count(1)?

Thanks a ton! I was going to use control panel but now I won't.

Do I need to stop the service, change the account and restart it or I can just...

Check SQL Server Log, there should be a success or failure message.

I would also suggest using table variable or temp table here, you can do:

SELECT code, description INTO temp_table FROM OPENQUERY(PRODJDE,' pdxcommon, 'SELECT * FROM concentration_units')

And then use this temp_table as:

select...

Thanks for the replies.

I have another question: since this a clustered index, just rebuilding this will automatically rebuild the other non-clustered indexes on the table or you have to...

To me also there is no correct answer....unless there is a AM/PM typo.

Prashant Pandey (12/12/2007)

---

But tell you the intresting thing that i have also ticked the 2nd option that is

3 types (DML triggers, DDL triggers and Logon triggers)

But if u'll read the...

I agree with rlondon. Answer should be 4; FOR is the only option available in earlier versions of Microsoft SQL Server for AFTER triggers and the question did not specifically...

The following will work even for the ms (milli second) unit of time:

select datediff (ms,getdate()-24,getdate())

Explanation can be found at:

http://technet.microsoft.com/en-us/library/ms189794.aspx