Use ALTER TABLE ALTER COLUMN to modify the column's datatype.

Greg

Yes.  See "Renaming servers" in BooksOnLine.

Greg

The only thing I could find, except for the idea that the schedule has an end date, is this: http://support.microsoft.com/default.aspx?scid=kb;en-us;295378&Product=sql2k

It might not apply in your case if you've got...

Deny EXECUTE permission on sp_start_job in msdb.  Make sure developers aren't sysadmins.

Greg

The output you provided looks like what you'd see in job history.  See the DTS package log for better error messages.  If you don't have logging enabled for the package,...

Check this thread from last October.  It concerned an import from Excel, but the same datatype mismatch could happen with Access.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=315637

Greg

Is the source on a remote SQL Server?  If it is, then you have to use the SQL OLE DB Provider rather than SQL Native Client.

Greg

sp_helpdb returns database name and status.  Look for Status=ONLINE.

Greg

It's pretty much the same.  The Import/Export Wizard still gives you the option to delete rows in the destination table before importing.  Just like in SQL 2000, you decide if...

Richard,

Are you running these stored procedures from a job or is this an OLTP system?

Greg

This issue has been around at least since SQL Server 7.0.  Recommendations for backup security include setting a password when backing up data, encrypting backup files, and storing backup files...

Teradata is an RDBMS used in data warehousing.  It's owned, I think, by NCR.

Krishna, rather than starting multiple threads about the same subject, it's less confusing for those wanting to...

Cross-post.  See responses in SQL 2000 Security forum.

Greg

As far as I know, SQL 2005 has no facility for viewing a 6.5 version database.  It either has be 8.0 or 9.0.  There's a bit of information in SQL...

No reason to make anyone execept DBAs/Administrators members of db_owner or sysadmin.  Users should be able to do everything they need through stored procedures for which they only need EXECUTE...