Viewing 15 posts - 886 through 900 (of 2,462 total)
sqlnovice2001 (10/21/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 22, 2012 at 12:18 am
Grant Fritchey (10/19/2012)
Why do you need to do this?
My guess ..interview Question 😛
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 19, 2012 at 5:47 am
see if it helps you
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 19, 2012 at 5:38 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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 19, 2012 at 12:47 am
deleting files on remote/shared location could be one reason.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 19, 2012 at 12:44 am
durai nagarajan (10/18/2012)
Is there a way to delete it automatically?
Scehdule a JOB 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 18, 2012 at 5:26 am
Read about CHECKPOINT
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 18, 2012 at 12:13 am
use varchar(16) instead of bigint
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2012 at 6:02 am
Viewing 15 posts - 886 through 900 (of 2,462 total)