Hi, i have done the full backup and would like to know how to protect the backup to avoid any one to restore it. Previously i am using WinZip / 7 Zip...
hi, recently i have make a mistake which i forgot to put in the 'where' statement and cause the all record from a table ( around 3 million )...
Hi, i am using SQL2008 Enterprise Edition and recently i have try to setup the Server Audit and Database Audit. I have usng 1 table for test and...
Hi, i have create a maintenance plan to do the daily full backup for my DB. i have set the Auto Shrink to true and Recovery Model for the DB is...
hi i have below script in store procedure : /////////////////////////////////////// Begin Transaction Begin Try Declare csXXXX Cursor For...
Refer to below SQL script Select Field1, Field2, ( Select Field99 from Table3 with (NoLock) Where .... ) Field3 from Table1 with (NOLock) Inner...
Hi, in BOL, only manage to get the way using Management Studio to enable disable SQL agent job, would like to check what is the transact SQL for...
Hi, i have below scrip to return the current cache SP + function execution for SQL Server. But the column CreateBy always return 'dbo', can i return...
Hi, currently i have 200+ store procedure in my database and i know a lot of them is no more using by program. may i know whether SQL server has a...
Hi, i am looking for some tools which can debug the store procedure which similiar to debug program source code. i am not using visual studio and...
Hi, my company just bought a new server with high powerful spec. currently i am using 1 server which is doing log shipping standby server, would like...
Hi, i have restore the full backup into secondary server and manual run the script to configure the log shipping setting. i also have copy the trx...
Hi, i am using SQL2005 enterprise edition and in my database got around 100 table. Part of it is History table. i would like to move all the history...
Declare @tableHTML nVarchar(max) Declare @iTotal int Select @iTotal = Sum(Balance) from CustomerProfile Set @tableHTML = N'<h2><u>Summary...
Hi, i got a table which has 100,000 record and i accidentally update the record without 'Where' condition, this cause all row in this table was get...
Hi, i got below sp which will calling back itself ( recursive ) in order to generate the hierarchy. Inside sp, i need to use cursor to hold the...
Hi, Anyone know how to convert number to word in Transact SQL ? eg 1268 to One Thousand Two Hundred Sixty Eight ?? Thank You !
Hi, after check the execution plan, query are almost same in terms of query cost. Just to check whether any other different between below quey ? and...
Hi, I got "timeout expired" error when I called a long query from my vb program. Although I've set the timeout properity for the ado connection to...
Hi, i got a store procedure which will return a record set as output. Just to find out is there any way to export the output from store procedure...
Separate names with a comma.
