Hi John,

This is a slightly confusing area with in SQL Server (but for a good reason) - Users and Logins are different things.

A login may be a Windows User with...

Tim,

If you are writing to disk then you might want to keep the INIT command as this will cause it to overwrite rather than append to an existing backupset (file)...

Try using the OSQL EXIT keyword

C:\>osql -E -n -Q "EXIT (SELECT 10)"

 -----------

          10

(1 row affected)

C:\>echo %ERRORLEVEL%

10

(if you wrap the script in EXIT then osql returns the last value selected in the...

Does the job email a named operator on success/failure?

If so you might need to script the operator (or add the operator to the server with the same name manually)...

Hi Imke,

I dont think you can do this directly from TSQL unless you want to use sp_OACreate to create a Scripting.FileSystemObject then use the GetDrive method of that (however OLE...

Hi there,

You want somthing like:

CREATE LOGIN James

WITH PASSWORD = 'Kjskd*&sd^^54665&';

USE AdventureWorks;

CREATE USER James FOR LOGIN James;

GO

The sytax is documented here:http://msdn2.microsoft.com/en-us/library/ms173463.aspx

Hope this helps,

- James

Hi Ronald,

I dont think there is a switch which does this however you can create a batch script which does it - osql handily lets you modify the return values...

Hi Brian,

I can think of one way of doing this off the top of my head but it might not be the best way but somthing along the lines of...

You might also want to look at using WMI to monitor your servers..

- James

Ahh replied at the same time as you did. Glad you got your problem solved.

- James

Simon,

Recreating/rebuilding indexes is a sure way to bloat transaction logs so I would suggest you make sure that isnt happening, other than that I can only suggest a large amount...

Hi there,

Not 100% sure if I understand quite what you are trying to do but...

A record's position within a table is not necessaraly defined by SQL Server. If you have a...

Another great small footprint database is SQLite (http://www.sqlite.org) I have used it fairly extensively at times and for certain applications its hard to beat speedwise.

SQL Server Compact Edition also...

Hi,

Red Gate software create a tool called SQL Compare - which has a 14 day free trial - which will do exactly what you want. You can find more information...

You might also want to look at using a third party backup tool such as Red Gate's SQL Backup which will perform the backup quicker, compress (and optionally encrypt) your...