Here is a modified SP_WHO procedurewhich returns more information about the current session.I forgot all the thing that i have added to the sproc, but the last addition shows the last executed TSQL statement.There might be a better solution to get the values from DBCC rowset, thou I did not have time to think everything […]
2002-05-28
707 reads
Procedure that net sends a message to any user who logged in as SA.IN. had to use this once in the company where SA password was blank for a while and managment did not want to set a password on the account. You can also set it to work with any username or for users […]
2002-05-14
876 reads
Here is handy procedure to generate random number.I find it useful when I generate large amount of test data in a database.For example if you need to create a Customer Data and what they have purchased in the last month to run perfrmance tests on large amount of data an set up necessary indexes.You can […]
2002-05-13
661 reads
Here is as sample of implementing cursor.In some cases my tests showed that this approach performs better than native cursors in SQL Server.All you have to do is move the dataset into a temp table with a new Identity column and then use a simple loop to extract the data as you would do normally […]
2002-05-06
1,968 reads
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
I’m excited to announce that on June 17 – 18, 2025, I’ll be running...
By Tim Radney
I have recently had the privilege of working with multiple clients who have been...
Hi Team, Can you someone suggest a few good third part backup tools, with...
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
Comments posted to this topic are about the item Meta AI by Facebook: A...
What does the monitor server do in log shipping?
See possible answers