Topics
Started by
Posts
Last post
hi All, i am able to restore TRN Files individual daily i am doing the same but i want to do it d…
1 replies
Hi. This is a straightforward one (i think ..). Does issuing a kill command to a session roll back …
6 replies
Hey everyone, I"ve recently started some dumping/loading of logs to a secondary server. I can confi…
6 replies
Hi, I have this sql... SELECT EPSReferralKPIs.dbPatID, EPSReferralKPIs.dbPatLastName, EPSReferral…
4 replies
Hi what is the difference between these 2 variables in store procedure: 1- the variables before As…
3 replies
Hi, We run a tran log backup on a 2008 Std Edition instance for each DB in full recovery mode, ever…
5 replies
I am getting the following error in my logs: Error: 18056, Severity: 20, State: 28. The client was …
1 replies
Split the string into two If the String lenght is 27 27- for 1 string 27*2=54 for 2 string 27*3=7…
3 replies
My database is in Recovery Pending mode Error: Unable to open the physical file.Operating system er…
11 replies
Hi , I had some data state,region and level wise which stored in table --> #temp_f I need…
6 replies
I can use Scope_Identity() to get the last identity value inserted into an identity column. But how…
1 replies
Hello, I validate my trigger entries like this: IF @Field = '' BEGIN ROLLBACK TRANSACTION G…
5 replies
I have a database which is used for a web application(not website). For each web application user,…
1 replies
1.Create the tables with insert queries 2. provide the result as required in an temp table 3. Disp…
4 replies
Hello I run code bellow. declare @SQLstring nvarchar(max) , @ExeCommand nvarchar(max),@OutString n…
1 replies
Viewing 15 topics - 8,371 through 8,385 (of 30,225 total)
You must be logged in to create new topics.