The  system proc sp_change_users_login may be able to help you fix the corrupted logins.

exec sp_change_users_login @Action = 'Report'

Will list users in the current database that are not correctly linked to a login...

Also, the BULK INSERT T-SQL command can be called from sql code, and it's as useful as bcp for importing files. In fact, it's faster than bcp because it lives inside...

Have you tried adding a column to the existing table, with a datetime data type, and using an update statement to convert the exisitng data?

UPDATE myTable

SET MyNewDTCol =

If you want to remove all the data from a table, use TRUNCATE TABLE because its damn fast. The transaction log will just contain the TRUNCATE TABLE command.

If you use...

Though this isn't tested code you could do something like

DECLARE @dbName varchar(256)
SELECT @dbName = Min(Table_Name) FROM TableHoldingTableNames
WHILE @dbName IS NOT NULL
BEGIN

   DECLARE @exportSQL varchar(8000)
   SELECT @exportSQL = 'bcp "SELECT TOP...

How are you attempting to do the backup ? using SQL DMO objects?

Have you tried a simple disk backup?

BACKUP DATABASE master TO DISK='C:\backuptest.bak'

RESTORE VERIFYONLY FROM DISK='C:\backuptest.bak'

You have a backup schedule defined but users still have permission to do ad-hoc backups?

I'd say the easiest fix is to remove everyones access to backing up. Then your schedule...

From BOL:

Check the...

If you want users to make changes / updates in Access, and for the changes to appear in a table that is stored in SQL Server, then create a Linked...

Read all the docs on DBCC optimisations. They detail their log usage for most of the commands. For anywhere where data is moved or changed, sql uses the transaction log.

You...

Shadow copy lets you backup those nasty .dll files and other files that are locked. Somewhat important for system state backups.

But obviously grabbing a sql database file off the disk...

Jeff is right TEXT is a whole different ball game. It operates in a similar way to the BINARY and IMAGE types, tagging bunches of separate data pages together to...

hahah. most DBA's have spare time while waiting for the server to catch up with them

DBA's do less programming, more planning, monitoring, optimising...

Read up on Permissions in SQL Books Online.

You'll need to take away the permissions of users (which can be set in the server, or database, or object).

DEFINATELY do...

Nope.

As Guy said, EM will actually create a new table with the IDENTITY setting, copy all your data into the new table, delete the old one, and rename the...