Topics
Started by
Posts
Last post
Use [MyDatabase] IF object_id('#Temp_Table') IS NOT NULL BEGIN DROP TABLE #Temp_Table Print…
4 replies
Is it right that you have to be a sysadmin role member to execute this sotred procedure in msdb. I…
1 replies
Use [myDatabase] Create procedure [dbo].[TestReturn] ( @Result varchar(50) output ) IF object_id('…
7 replies
I have a SQL 2005 database that was migrated to SQL 2008. If I write this: USE [ProductDatabase] SE…
5 replies
hi i have a two table select*from phon phone ASA 111 james 222 stivens 333 null 444 null select*fro…
2 replies
i would like to find whether the login belongs to group or sql user \windows user in sql 2005\sql…
1 replies
I need to take salary and add a 10 percent increase to it and display the results Will something li…
5 replies
Hi All I'm making a change of the database properties, so enabling ALLOW_SNAPSHOT_ISOLATION to ON. …
4 replies
Hello Everyone, Is there a T-SQL script to automatically restore the transaction logs just like wha…
24 replies
Hello, I have table with columns of type int. I export this table by using bcp: bcp dbo.int_table o…
6 replies
Hi, please let me know what are the transaction undo files means. Thanks.
4 replies
These two queries give the same result. Which of both is the best?? Is ther a way to avoid or make …
3 replies
Hello all, I am having trouble switching backups from local disk to a network share. I know this is…
8 replies
Hi I found this to convert at date cast(cast(sq.QuotaDate as date) as varchar(7)) and it works by g…
3 replies
Why is it not good practice to use Wizard when creating a maintenance plan? Most DBA's recommends c…
8 replies
Viewing 15 topics - 7,876 through 7,890 (of 30,225 total)
You must be logged in to create new topics.