Viewing 15 posts - 2,566 through 2,580 (of 7,429 total)
But as for answer to what to do. If you have good system files then yes sp_attach_db or sp_attach_single_file_db if the LDF has any issues.
September 5, 2003 at 7:43 pm
Again I go back to the Standard debate I keep bringing up. Although the OS is clustered a single instance is running as a secondary instance on one node. I...
September 5, 2003 at 7:41 pm
quote:
quote:
The only way around that in Windows 2000 is through VMWare, which limits the...
September 5, 2003 at 7:35 pm
quote:
I would be extremely leary with this interpretation based on comments I've seen in other forums. You may have limited the #...
September 5, 2003 at 7:32 pm
Could have something to do with clustering that I have not seen. But alas no cluster to test on.
September 5, 2003 at 1:18 pm
quote:
But you can't cluster Standard Edition, so all of the instances have to be the Enterprise Edition.-SQLBill
September 5, 2003 at 1:15 pm
DOes the entry date have an index on it and id the id field an indentity field that increments each entry and thus should have a value that will always...
September 5, 2003 at 1:01 pm
From SQL BOL
quote:
sysadmin - Performs any activity in SQL Server. The permissions of this role span all of the other fixed server...
September 5, 2003 at 12:48 pm
quote:
I had similar problem with my Developer and Production environment when I used count function with (IS Not Null) condition in the...
September 5, 2003 at 9:17 am
I have a test copy of CE but not installed on my Pocket. I will try to find and install but you might try the msdn website and search for...
September 5, 2003 at 9:15 am
Also we are dealing with a cluster. No statement is given to Active/Passive or Active/Active state which means you have to only licenses for the Active machine. Which if in...
September 5, 2003 at 9:12 am
From my understanding it should be. The parser is pretty much the same.
September 5, 2003 at 8:50 am
Sorry I meant in you ASP.NET do a query call to do 'SET ANSI_NULL OFF' this will remain in effect for the duration of the connection. After that is run...
September 5, 2003 at 8:21 am
I have not seen issues with triggers from a backup in 7 to restore on 2k. But as for replication I always get the message database was under replication but...
September 5, 2003 at 8:07 am
quote:
So refreshing to start the day with a lighter note. Thanks for the break all.38. Late starter - married 9 yrs with...
September 5, 2003 at 8:04 am
Viewing 15 posts - 2,566 through 2,580 (of 7,429 total)