network profile
| bio | website | |
|---|---|---|
| location | LA | |
| age | ||
| visits | member for | 7 months |
| seen | Jan 31 at 16:36 | |
| stats | profile views | 8 |
MSSQL DBA
|
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 |
|
Oct 25 |
awarded | Editor |
