Viewing 15 posts - 4,501 through 4,515 (of 7,191 total)
Yes, open, convert, save.
There may well be a quicker method, but I'm not aware of it. The internet is a great resource for stuff like this, if you choose...
May 28, 2012 at 1:38 am
The account that runs SQL Server needs read permission on the folder that contains the file you're importing from.
John
May 28, 2012 at 1:33 am
You mean a mapped drive - N:\MyFolder, where N: is mapped to \\MyServer\MyShare? Better to use a UNC, since the code will be executed in the context of the...
May 25, 2012 at 9:57 am
This is the line you need to change:
SET @bcpCommand = @bcpCommand + '''' + @assetNumber + ''''
John
May 25, 2012 at 9:50 am
Open them up in Visual Studio 2008, wait for them to be converted, then save them to msdb on your 2008 server.
John
May 25, 2012 at 9:11 am
The best thing to do is to set up a disk as a clustered resource in the same group as your instance. That way, if SQL Server fails over,...
May 25, 2012 at 8:43 am
May 25, 2012 at 1:47 am
I'm afraid I've never worked with Oracle. Is there anything in the Oracle syntax that allows an explicit conversion to an Int32-equivalent type?
John
May 23, 2012 at 7:27 am
Jim
You need to do more than set the value of a variable in T-SQL. You need to get it into an SSIS variable. The best way of doing...
May 23, 2012 at 4:04 am
Bryan
Does the user test_acc\SYSTEM have access to the server? Is the server configured to log failed logins? If so, what errors are appearing in the errorlog?
John
Edit: just...
May 23, 2012 at 3:08 am
Yes, you can. But I'm afraid I can't do that for you - it'll depend on your exact requirements. I use SSIS for stuff like that. You'll...
May 23, 2012 at 2:59 am
No. There are three things that can happen:
(1) The restore fails, in which case you know it hasn't worked.
(2) The restore succeeds but DBCC CHECKDB highlights issue, in which...
May 23, 2012 at 1:49 am
You'll want to test before you make any changes that affect all operations on the server. You could end up breaking something else. It may be safer just...
May 22, 2012 at 6:39 am
Just put that code above into a job step and run it. I think you can configure the job to save its output to a file in case there...
May 22, 2012 at 5:52 am
Viewing 15 posts - 4,501 through 4,515 (of 7,191 total)