Be wary of these 'auto-magic' features in EM. On large tables you may be looking at an hour glass for quite some time. I've always found it best to script out...

Having performed this type of task with various Access versions from 95 to 2000 I'd opt for Parker's method at a minimum. At times I've had access to software like...

Just to answer the original question:

declare @cmd varchar(255)

create table xp_cmd_output (xp_output_line varchar(255))

set @cmd="your winzip/pkzip/7zip/winrar/etc command line string"

insert into xp_cmd_output

    exec xp_cmdshell @cmd

select * from xp_cmd_output

SQL v7 had an option on the installation CD that 'you had to trust' ... it worked 98% of the time. As for SQL2000, the sp_dropserver/sp_addserver/reboot is still the 'correct'...

Since you are installing MSDE there is a specific 'bug', at present known by Microsoft, but undocumented to the general public. Here's the thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=204414

Michas Konstantinos description is brief and...

You've gotta love 'cowboy' environments ... no one seemed to think about going to their 'source code control system' for the stored procedures ...

FoxPro originally was a desktop database engine for small stand-alone applications (like Access, FireBird, Paradox, etc.). Now it is being used as a communications front-end to SQL Server in some...

SET [Sybase DBA mode] ON

go

How about this:

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/40544

Here's a good detailed explanation (page 411 in the PDF file:

http://www.nd.edu/~ddenting/reference_manual.pdf

SET [Sybase DBA mode] OFF

GO

The include/exclude lby line, line/column/block of code for edit change/replace of a venerable old product - TSO SPF/EDIT from the mainframe world. The global search and replace regular expressions of EditPadLite...

" Only thing that happened was one of the filegroups on one database got filled up and it logged too many error msgs in sql log but is that what...

Let's see now ... I have a number of clusters in production today.

My clusters posess:

  --> 1 IP for physical node A

  --> 1 IP for physical node B

  1...

Just a silly question to start - are you performing the OS installs as a member of the LocalAdministrators group ? I had to ask because I've recently moved a...

Things can be simple. Don't let the 'potential gotchas' interfere with the goal. Try the 'Upgrade Wizard' on a test database. It does produce an audit of what issues it...

Could you provide a little more detail on what the Job is supposed to do ? Can you post the SQL (if relevant). Is this a new Job or is...

You canot retrieve the file but you can cover yourself in the future by configuring the SQL Server to keep more log files. I personally recommend 20 since it will...