Viewing 15 posts - 26,056 through 26,070 (of 39,800 total)
you handle this in two ways.
1. You add the fix to v2 and either accelerate testing, or they wait for it to finish.
2. You make a change to v1, test...
December 8, 2008 at 12:50 pm
I've never had good luck doing this. The script might work, but honestly, recreating them isn't that bad, even on dozens of instances and it's a one time task.
December 8, 2008 at 12:48 pm
You should be using ALTER DATABASE to change the size and then restart SQL Server.
December 8, 2008 at 12:48 pm
The older DBLib stuff might work (based on named pipes).
However you need some way to connect from Windows to Sybase, and once you have that, it's possible that you can...
December 8, 2008 at 12:48 pm
You can do this multiple ways.
You can insert all the data from the restored tables, which may result in some duplicates if you don't have constraints to overwrite this.
You can...
December 8, 2008 at 12:29 pm
Thanks for the update and glad it worked.
As an FYI, I don't recommend dump devices and would just back up to disk files. I'd use a different file name every...
December 8, 2008 at 12:26 pm
I think what someone is asking is how many rows are in the table when you start (last week and this week).
Are you adding indexes later?
Could you be adding enough...
December 8, 2008 at 11:42 am
What's wrong? the older drivers from 2000 should work, although some of the newer features and keywords might not work.
December 8, 2008 at 10:41 am
How is the login that is having issues connecting to SQL Server? As a SQL login? It won't have Windows credentials to pass through the linked server.
December 8, 2008 at 9:47 am
There are not files within a .Bak file. There might be multiple backups stored within one file, but you cannot delete some of them now. You should back up to...
December 8, 2008 at 9:42 am
I'd set an view up on the linked server, select a, b, c from newserver.newdb.newtable, and then use the view for updates. That way you won't have to...
December 8, 2008 at 9:11 am
Not many people auditing, or maybe caring, ...
or maybe awake :hehe:
December 8, 2008 at 9:09 am
What version/edition of SQL Server is this?
It's got to be auto-close somewhere. Be sure you're not getting auto-close for another instance. Code might do it, but I can't imagine anyone...
December 8, 2008 at 8:46 am
Only if you send HTML mail and put color code in it.
December 8, 2008 at 8:44 am
Or create a quick VM, restore MSDB to a SQL instance there and then script out the jobs.
I'd keep a VM around for stuff like this, install Windows, SQL, then...
December 6, 2008 at 10:00 am
Viewing 15 posts - 26,056 through 26,070 (of 39,800 total)