Viewing 15 posts - 46 through 60 (of 812 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...
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
July 5, 2012 at 8:19 am
change the "reference number" to auto-increment which will take care to generate the unique number everytime.
----------
Ashish
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...
----------
Ashish
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.
----------
Ashish
July 5, 2012 at 4:50 am
try modifying your select your query with hint as "nolock".
----------
Ashish
July 5, 2012 at 3:09 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'','','')
----------
Ashish
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 =...
----------
Ashish
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...
----------
Ashish
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"
----------
Ashish
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....
----------
Ashish
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
http://www.sqlservercentral.com/articles/Upgrade/65872/
----------
Ashish
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:
----------
Ashish
June 14, 2012 at 10:59 pm
Viewing 15 posts - 46 through 60 (of 812 total)