quote:Originally posted by california6 Msg 8101, Level 16, State 1, Line 1 An explicit value for the identity column in table 'trace1' can only be...
You haven't SELECT'ed anything to be inserted... If you created your table from SELECT * INTO Trace_Table FROM...
quote:Originally posted by DilliGrg Why don't you save the file to Table while running the profiler? You can choose this option while setting up for...
Most of the decryption routines for stored procedures that you find will need to 'clobber' the original procedure in order to determine a known hash....
You're quite welcome. It was a confusing topic for myself as well, until I spent some time with it and finally learned how.
This is a function I wrote to 'decode' a bitwise stored column that I use to drive my backup routines. It's fairly straightforward and should show...
Remember, in SQL2000 FullText catalogs are NOT included in the backup. In 2005 FT's are included in the full db backup, but that's not going to do...
quote:Originally posted by CG2000 The process you describe is an application/SPROC you have written to create a 4 snapshots per hour? Or are you...
What I do is name my snapshots as follows: <SourceDBName>_Snapshot_<TimeStamp> and leave the last four snapshots available. The process that...
quote:Originally posted by CG2000 2.) - but you can only have one snapshot per source db, and it reflects only one point in time. Actually, you...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Find the topic "Monitoring with SQL Profiler Event Categories" in Books Online.
The event class you are tracing does not provide data for those columns... See Gert's chart for a complete matrix of events & objects:...
Sorry, not going to happen. You have to create a new database on the 7.0 server, generate object scripts to create in the new database and then move...
quote:Originally posted by MohammedU I don't think snapshot isolation level will eliminate all dead locks specially when you are doing...
From a Windows XP workstation commandshell execute: shutdown -f -r -m \YourServerName It may take a while if your server is hung up in some odd...
A normally issued reboot command will shutdown the SQL Server in an orderly fashion. No need to stop the services beforehand...
Actually, it doesn't sound like it needs to be rebuilt from the ground up...<br /><br />1st -- Move the SQL resources out of the Cluster Resource...
The snapshot is initially created as a "sparse" file. As data changes in your source database and you take snapshots your snapshots will only grow...
FYI -- If you install SP2 the Script to multiple files now works.
Separate names with a comma.
