317 reputation
16
bio website
location LA
age
visits member for 1 year, 6 months
seen May 29 '13 at 1:34

MSSQL DBA


Dec
27
awarded  Yearling
Jan
22
comment RAND in T-sql function
we use mssql 2008 enterprise edition
Jan
22
asked RAND in T-sql function
Jan
17
comment How to create an object and then alter it
IN choose script options you can make "Include if NOT EXISTS" to False
Jan
12
comment Allowing end users to kill their own queries
we can do in MSSQL server by getting spid of a particular user and kill that session , but it wont be good thing giving permissions to users for Killing spids... i think your dba's can do it if they are ok for this one.
Jan
11
awarded  Critic
Jan
9
answered Find fulltext indexes in SQL Server 2008
Nov
30
awarded  Supporter
Nov
5
answered Insert ignore with conditional
Nov
2
comment sql server removing service_queues
How can i drop queue if any services refer to the queue.
Nov
2
comment sql server removing service_queues
No i tried it gives the error, Cannot drop the queue '_LakeSide_DbTools_LockQueue', because it does not exist or you do not have permission.
Nov
2
awarded  Student
Nov
2
asked sql server removing service_queues
Oct
29
answered Execute job every time database changes - execute job on each change-event
Oct
29
answered Conversion failure varchar to int
Oct
26
comment Save data to variable and use it in stored procedure
Hi edited according to your request, if you want to change table name you have to use dynamic T-sql .
Oct
26
revised Save data to variable and use it in stored procedure
added 242 characters in body
Oct
26
comment Save data to variable and use it in stored procedure
ya it can like IF @userDate>your variable
Oct
26
answered Save data to variable and use it in stored procedure
Oct
25
awarded  Custodian