Viewing 15 posts - 36,511 through 36,525 (of 39,771 total)
That thing is flaky. I'd not use it.
If you can afford downtime, right click the db, all tasks, detach db. Copy the mdf/ldf to the new server and then right...
March 7, 2003 at 11:53 am
Slight caveat.
You can run v6.5 as the first instance and 2000 as other instances.
It is in SQL Server 7.
Not sure you need separate IP addesses. Why not separate databases?
Not...
March 7, 2003 at 11:51 am
run sp_detach_db <db name) to detach the databases.
Then copy the .mdf and .ldf files to the new server and attach them.
http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp
Steve Jones
March 7, 2003 at 10:39 am
Test taking is always a double edged sword. The goal is to learn things, but if you don't pass the test, which is only pass/fail, you are stuck. It's time...
March 7, 2003 at 9:56 am
Not familiar with Filemaker either, however As Antares mentioned, I think you need to weigh the upgrade costs (software, time, development) and see. IF Filemaker isn't performing and something needs...
March 7, 2003 at 9:50 am
Glad to help. Threw me for awhile as well. just kept trying things.
Steve Jones
March 7, 2003 at 9:43 am
You might have to run a sniffer for this. SQL Server responds when someone attempts to connect with the login informaiton. Not sure that Profiler traps this since the user...
March 7, 2003 at 9:35 am
Not sure how it can be changed, but this should be no impact to the use. Are they still owned by dbo?
It should be sysadmin only. I suspect that someone...
March 7, 2003 at 9:30 am
March 6, 2003 at 11:11 am
Not sure this is supported in DTS. Have you tried a linked server?
Steve Jones
March 6, 2003 at 10:57 am
Not a DMO guru, but it appears script is for dbs (existing) and generate is for other objects.
Is definitely poorly written.
Steve Jones
March 6, 2003 at 10:43 am
sp_helpdb, etc. There are numerous stored procedures the produce the information you seein Enterprise Manager.
Steve Jones
March 6, 2003 at 10:26 am
I added an alert with Buffer Cache Hit Ratio, falls below, 0.97 and it worked. I tried .97 and got an error. 97 worked just as you mentioned.
This is SQL...
March 6, 2003 at 10:20 am
Does the stop screen in services just hang? Does it report an error? Have you checked the SQLAgent log and the Event Log? It might be rolling back. Check sp_who2...
March 6, 2003 at 9:59 am
Don't think you can. I think the per seat to cpu is the only conversion.
The uninstall/reinstall isn't that painful. detach the dbs, uninstall, then install and attach. If you've got...
March 5, 2003 at 11:32 am
Viewing 15 posts - 36,511 through 36,525 (of 39,771 total)