It has been there since 6.5 - but I cannot guarantee about future versions.

General Network error is very generic, as it states - it is hard to jump to a conclusion or determine the cause. I have seen it coming up if the...

Although not recommended, u can create a trigger on sysconfigures. User options are based on connection.

try looking into the documentation for

DBCC USEROPTIONS

Use the user options option to specify global defaults...

SELECT fileid, name, filename, size, growth, status, maxsize FROM dbo.sysfiles WHERE (status & 0x40) <> 0

DBCC sqlperf(logspace)

DBCC showfilestats [undocumented]

It is just confusing terminology. Tape Device can have the same disk backup file (backup device in terms of HDD) - offcourse in the MS Tape Format.

You can have SomeDBBakup.BAK...

SQL Server Terminology has different meanings for Servers, Named Instances and Databases. You cannot have 2 databases or two named instances with same name.

If u do a Select with LastModifiedDate in the paramenter - does the select return data?

What r the exact table names for both tables. Turn on the profiler trace and run UPDATE on both check what happens?

Helen

Please have a look @ http://support.microsoft.com/?kbid=902388

This problem is by product design. U cannot have two backup plans for the same database - either u choose backups or Log shipping, because they essentially mean the same...

If the database was not shutdown cleanly before detach it is not possible to attach the file using sp_attach_db or sp_attach_single_file_db.

Try this:

Checking Files before Attaching

You should note that you...

search BOL for inserted tables

Str or convert or cast function can change the datatype

information_schema.columns can give u the list of columns in a table

SELECT user_name() will give u the username

If you run the following with actual parameter values, does that work?

UPDATE dbo.Document

SET DocTitle = @DocTitle, ReviewEvery = @ReviewEvery, Obsolete = @Obsolete, ObsoleteDate = @ObsoleteDate,

Comments = @Comments, OldDocNo =...

Run the TSQL (xp_cmdshell) script inside the package in Query Analyzer and find out the error. Use the same login which is used by the package to run. Le me...

Try the Select without the sp_execute with all parameters and check the performance. Isolate the problem further by trying it locally on the server and from the client to rule...