Search results for query: *

All very valid points.

George, thanks for being very thorough. MSFT has 1 KB article which says that updates and inserts will fail as you've nicely demonstrated. What they don't have is any document which states the data will remain safe (think back to a federal mandate for this data) and of course, to make matters...

MDXer, you're assuming I haven't asked the vendor. That would be incorrect. My current task is to guarantee the data is safe. Pointing fingers is another discussion.

George, thanks for the demo. However, I need proof from MSFT given the federal regulations around the type of server.

Certainly doesn't look like you're really using the disks much from the numbers you posted. For example, I just looked at one of my old servers and it's puttering along at 1500 i/o per second right now which is a very slow time of day...... Post the logical disk and physical disk %times...

monksnake, the link you provided doesn't offer any position from Microsoft on whether this is supported or whether, as gmmastros states, some updates may corrupt the data. The article states inserts and updates will fail.

George, Do you have any whitepapers, etc. for this? I'm working on a federally regulated server and I need something, preferably from Microsoft, which details what you've noted.

We're getting the "exceeds the maximum numberof bytes per row (8060)." error in sql 2000. Does anyone have any kb articles , whitepapers, something else from Microsoft which acknowledge the problem AND indicate it's ok to proceed? The one article I've found from MSFT simply notes that...

That's all great. How can I get rid off the "spool off" at the end of the file??

I want to spool my results without the SQL> in my results: SQL> col1, col2, col3 etc. How can I get rid of the SQL> in the spool output?

I've heard deleting the subplan will do it for you and renaming the job will also do it. Haven't tried either.

Dim oServer Dim oDatabase Dim oBackup Dim sBAKFilePath 'change this to where ever you want to place your backup files, no trailing 'backslash, we add it below sBAKFilePath = "C:\BackUp" 'we need a backup object in addition to the sqlserver one Set oServer =...

The restore took so long because the log file had to be created. In sql 2000 this is a sloowwwwww process. SQL 2005 is supposed to have instant file initialization though I can't vouch for it.

Just waxing philosophic here: egg.x.com is not the same as egg.y.com so why can't they be on the same network?

In case Paul's solution isn't it, I'd try running it from the command line and see if that works. What version/spk are you at?

Did it ever work?

You need to check out majority node set clustering. Or Veritas Cluster services.

You can go into the active node and restore the databases but should make sure you're aware of what's going on with resources, etc., first. Check out cluster administrator to determine what node is active.

First of all, @@version, and more details about the db and table would help such as number of rows. >Currently the Clustered Index is a Decimal, with a precision of 18, which is 9 Bytes. I want to change it to INT, so it take only 4 bytes. Will that help with performance? or just lessen the...

Sung to the tune of Oscar Mayer weiner Oh I wish I were A Microsoft Product support specialistttt, That is what I'd really like to beeeee eeee eee. Cuz if I were a product support specialisssttttt, Everyone would be ticked of at meeeeeeee.