Viewing 15 posts - 31 through 45 (of 116 total)
Also, you should probably not be querying sys.dm_exec_sessions, sys.dm_exec_requests, or sys.sysprocesses directly becuase you probably won't have the correct permissions.
Maybe that's why I never got it to work properly, but...
January 2, 2009 at 11:35 am
We maintain a database called the Data Quality Engine (DQE) into which an operator can insert various kinds of tests that target data either on our SQL Server or Oracle...
November 21, 2008 at 10:32 am
My favorite subject line of all time:
"Increase your income by becoming a Sociologist"
November 7, 2008 at 1:03 pm
rudy komacsar (10/14/2008)
... and also ...exec sp_help 'Tablename'
You can also select the table name and hit alt-F1 which is the shortcut for the code above.
October 14, 2008 at 6:17 pm
Vladan (9/29/2008)
the use of DATEADD and DATEDIFF functions looks a bit strange at first, but is more efficient - and also more flexible. Once you learn how it works, you...
September 29, 2008 at 10:46 am
Why do summersaults with the date like that? The convert() function works well. One of my favorite uses is for the 'YYYYMMDD' output using 112 as the input "style" argument....
September 29, 2008 at 12:33 am
You can get a lot of information out of the information_schema views. See BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/7e9f1dfe-27e9-40e7-8fc7-bfc5cae6be10.htm
If you join the views in a clever manner, you can show each column as well as...
September 16, 2008 at 10:06 am
The error is being caught properly, but the error state is not being reset for the error_message() and error_line() functions. They continue to return stuff and it messes up the...
September 14, 2008 at 12:11 am
I have several layers of nested procedures and when it reached trigger time, @@spid returned the top executing sproc rather than the update sproc, so it failed out. The only...
August 14, 2008 at 12:01 am
Almost!
Sometimes sys.servers does not have a record for @@ServerName to return, so it comes back null.
The foolproof way is:
select @server_name = cast( SERVERPROPERTY( 'servername' ) as sysname )
July 19, 2008 at 3:30 pm
That's true: I can double-click in registered servers, but I would still like to script it out in T-SQL and avoid all that clicking.
June 25, 2008 at 1:16 pm
GSquared (6/25/2008)
If I'm reading this correctly, there's an option in Management Studio to open the object browser when you open Management Studio. Does that do what you need?
No, I'm...
June 25, 2008 at 11:27 am
And, I figured it out shortly after posting!
The problem is that the job deployed to production was pointing to the package on the development server. It's intermittent because those days...
April 2, 2008 at 3:00 pm
Thanks a lot, that did it!
February 11, 2008 at 12:45 pm
Steve Jones - Editor (10/30/2007)
October 30, 2007 at 9:17 am
Viewing 15 posts - 31 through 45 (of 116 total)