Viewing 15 posts - 886 through 900 (of 2,463 total)
SELECT DISTINCT o.name, o.type_desc FROM sys.sql_modules m JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition LIKE '%view_cu_Account_Bills_b%'
October 23, 2012 at 4:25 am
sqlnovice2001 (10/21/2012)
October 22, 2012 at 5:45 am
Since you are dealing with good numbers of message to END the dialog.it wil take some time as every record will get processed with per ConversationHandle.Rerun will be there sonce...
October 22, 2012 at 1:26 am
thirudwh (10/21/2012)
I am new to SQL Server,i have requirement to run backup using stored procedure.
I am using a stored procedure to call backup command,before backup need to include a step...
October 22, 2012 at 12:18 am
Grant Fritchey (10/19/2012)
Why do you need to do this?
My guess ..interview Question 😛
October 19, 2012 at 5:59 am
kranthi.india123 (10/19/2012)
nothing but,rather than domain based.
but why you want to avoid domain based account ?
October 19, 2012 at 5:47 am
kranthi.india123 (10/19/2012)
Ensure that the account you are using on the server is a local one (rather than domain based).Thanks,
i didnt get this point
October 19, 2012 at 5:33 am
Ratheesh.K.Nair (10/19/2012)
Thanks everyone for the quick reply.I am a DBA and need to have access to that server. Is there anyway to get access without a restart??
Why restart...
October 19, 2012 at 4:49 am
Ratheesh.K.Nair (10/19/2012)
but have only limited access to SQL Server.
What kind of limited access ? and can u able to login through sa sql authentication
October 19, 2012 at 4:25 am
baabhu (10/19/2012)
We managed to schedule it that 4 minutes job starts at odd minutes and the 10 minutes job starts at even minutes.Chances of intersecting is very rare.
NOt...
October 19, 2012 at 4:14 am
Chad Crawford (10/18/2012)
The query is executing the sp_columns system stored proc, which returns information about a table column, given the table and column name.
Why dont you try sys.columns or...
October 19, 2012 at 12:47 am
deleting files on remote/shared location could be one reason.
October 19, 2012 at 12:44 am
durai nagarajan (10/18/2012)
Is there a way to delete it automatically?
Scehdule a JOB 😀
October 18, 2012 at 5:26 am
Viewing 15 posts - 886 through 900 (of 2,463 total)