Hi all I am getting this error message on one of my servers. Has anyone encountered this before? I got this error message last night and night...
Does anyone happen to have any code to update a table column with random integers? Also if you got something similiar with dates but in order that...
Time to celebrate [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] I start my new job in 2 weeks. [<img...
I have to seem forgotten or dont know if it exists. I want to query a Role and get all permissions, like you would in EM but do it from Query...
I just installed a new SQL Server. I created some alerts on this server, but they dont seem to fire. For instance I just created a log failed alert...
For anyone that has had the opportunity to work with Windows 2003 Server can you please Share your experiences like what are some of the major...
On one of my Web apps Profiler has been reporting a significant amount of sort warnings. Is there a way I can capture which queries are causing this...
SELECT STUFF(Prov_RFC,4, 1, '-') How can I use this same formula but to insert the dash from e characters from the right. I need to convert...
A Developer is using getdate() to return all rows from SQL Server in a DateTime Column. However not all rows are being returned due to time...
I am using the Transformation Task to copy columns from a view to a table. The view is a denormilized table some, of the values in the new table will...
Does anyone know where I can find resources on the use of group numbers in stored procedures. I tried searching BOL but couldnt find anything. Are...
Today I was surfing the internet for some scripts and found this site. I was blown away! http://www.lazydba.com Why Lazydba? The philosophy...
Does anyone have any scripts to run update stats on all databases on a server?
What is the quickest way to transfer an 80GB database from on server to another?
I want to update a table column with values 500- 1000 for istance lets say the table already contains 500 records there is a column that is null I...
Is there a way I can print out query the notes in the column properties.
EXEC master..xp_cmdshell 'xcopy "D:Program FilesMicrosoft SQL ServerMSSQLBACKUPDB_backup_device.bak" \SecondServerShare /C' When this step executes...
After a lot of trial and error I almost got it. I am passing an xml string to a stored procedure from ASP. Everything almost works exept when it...
I created a Virtual Directory in IIS with with two virtual names Schemas and Template. Im new to XML where do I store these templetes and how do I...
Whats the best method to pass an array to an SP using ASP. For instance if you have an order and want to add multiple orderdetails to the order....
Separate names with a comma.
