Viewing 15 posts - 35,041 through 35,055 (of 39,793 total)
You need the ODBC drivers from the Linux side to access the SQL Server. Not sure since I haen't done this, but it should work if the DB2 Federated links...
April 25, 2004 at 10:05 am
sp_who2 from a query window will get this as well (and it's quicker).
April 25, 2004 at 10:03 am
You ought to be able to use Access as well to link tables from the MSDE. I know I've done this with SQL Server databases and it should be the...
April 25, 2004 at 10:02 am
Great tip. I didn't know this, but it could be a great help in any custom procedures that you need to pass a parameter in on.
April 23, 2004 at 2:05 pm
You can backup to a remote drive using a UNC path, like backup database to disk = '\\webserver\share\folder\file.bak', however the backup procedure isnt' very tolerant of delays.
Instead I'd write the...
April 23, 2004 at 2:03 pm
It's hard to make a good recommendation from a very limited description. If these are small dbs, I'm not sure the recovery time and all app availability matters. If we're...
April 23, 2004 at 1:59 pm
Not seen things like this specficially, but the Siebel app we used to run on v7 had performance issues. Strange things between the app and db servers, never really tied...
April 15, 2004 at 1:23 pm
Has it ever worked? I suspect your installation has issues. If you can, I rerun the setup. Be sure you backup your databses, script logins, etc. first.
April 15, 2004 at 1:21 pm
Have you checked the proxy account checkbox for security in SQL Server Agent properties? I believe if you haven't done this, only sysadmins can run xp_cmdshell successfully.
April 15, 2004 at 1:18 pm
Also, run the queries in Query Anayzer with the execution plan (CTRL-K) set. This can help pinpoint how the query is running and any hot spots.
Brian Kelley has a...
April 15, 2004 at 9:32 am
How much memory is on the machine? What else is running?
On a 4GB server, I expect SQL to run steady at 1.7GB. On a 2GB machine, I think it's usually...
April 15, 2004 at 9:19 am
The suggestions above are great ones. The attach merely picks up the files that are there. If you got one file and not the other, it would error out because...
April 15, 2004 at 9:03 am
That's your best option. No "throttle" per se, which is something I've asked for. Send that to sqlwish@microsoft.com and maybe we'll get it some day.
Be sure you test this...
April 15, 2004 at 8:59 am
Why do you need to migrate? Can you not rerun the indexingf on the target server?
April 15, 2004 at 8:55 am
Hmmm, not sure. Perhaps including the domain name in the user id call? mydomain/myuser?
April 15, 2004 at 8:54 am
Viewing 15 posts - 35,041 through 35,055 (of 39,793 total)