Viewing 15 posts - 46 through 60 (of 816 total)
i have a Stored Procedure (SP1) which calls multiple other Stored Procedures.
I've noticed that a call to one Stored Procedure is not being made from SP1.
I'm wondering whether it was...
July 10, 2012 at 4:05 am
I havent checked your syntax but just going by your word, I am expecting you looking for some solution which can change the database to simple recovery and which you...
July 10, 2012 at 3:59 am
I dont think we need this much big line of code to delete a file.
I have one SP which need the input parameter as fullpath+filename and will delete the file.
The...
July 9, 2012 at 10:18 pm
try connecting with port number. for ex, servername\instancename,portnumber
or
ip\instancename,portnumber(if its non cluster and have more than 1 sql instance)
or
ip,portnumber when server is cluster server and you have dedicated ip...
July 5, 2012 at 8:19 am
change the "reference number" to auto-increment which will take care to generate the unique number everytime.
July 5, 2012 at 6:29 am
hello fellas,i need some code or logic that will always provide the last day of any year.i know its a vague question but any help is appreaciated. thanks
I think as...
July 5, 2012 at 5:14 am
at first look, seems like
the source/destination path issue.
or
the permission issue on folder for the account which is running the job.
July 5, 2012 at 4:50 am
then I guess its breaking here
WHERE id IN (select Item from dbo.FN_DELIMITED_STRING_TO_TABLE(''1000,2000,3000'','',''))
what kind of table is this?
dbo.FN_DELIMITED_STRING_TO_TABLE(''1000,2000,3000'','','')
June 15, 2012 at 6:40 am
EXEC sp_executesql N'SELECT [id]
FROM [dbo].[test] WITH (NOLOCK) WHERE id IN (select Item from dbo.FN_DELIMITED_STRING_TO_TABLE(@1,'',''))
ORDER BY id',
N'@1 varchar(MAX)',
'1000,2000,3000'
try this
declare @sql varchar(max)
set @sql =...
June 15, 2012 at 5:15 am
restore it. You will come to know if its native(SQL) backup or third party.
If the backup file is of third party, you will get error which if you put...
June 15, 2012 at 5:12 am
you should have one clusteradmin group first.
this group will be the parent for your "sql admin group" and "sql service account"
June 15, 2012 at 5:07 am
This took approximately 1 hour to load 168,261 rows.When I used a linked server and a Select into statement it took 10 seconds.
This should not be the case....
June 15, 2012 at 12:16 am
you have the two option to consider
1) Inplace upgrade
2) Side by side upgrade
More detail is here
June 14, 2012 at 11:18 pm
if you manage the environment then why wasting time to dig the old password. Reset it with something else and let vendor chase you :w00t:
June 14, 2012 at 10:59 pm
Viewing 15 posts - 46 through 60 (of 816 total)