Bhimraj

So you're not doing any transaction log backups at all at the moment?

John

Have you read about computed columns? I think this would be a better solution than a trigger.

John

Please will you provide table DDL (in the form of a CREATE TABLE statement) and sample data (in the form of INSERT statements) to help us to help you.

Thanks

John

Jay

Are you specifying the server name correctly, complete with instance name if appropriate and port number if necessary? You could try either looking in the errorlog of the server...

Why would you delete a contact just because he has the same first name as another contact? If you insist on doing this, create your foreign key constraint with...

Profiler will capture (the whole of) every statement executed on the server, subject to any filter placed on the trace.

http://technet.microsoft.com/en-us/library/ms175047.aspx

You don't. You link it to SQL Server at the same time that the web page is running. That way you can capture the SQL that is being...

OK, so you need to turn it into a stored procedure. You need to use dynamic SQL to build the query, a bit like you were doing in the...

As I understand it, you can't shrink the files smaller than the size of the model database, but you can shrink smaller than the creation size of the database if...

No, that's the errors you get if you run it from SSMS. You said you were running it from a web page. I think you need to ask...

In that case, you ought to check with your DBA.

John

Maybe it would if it were run from the right place -...

Depends on what you're trying to achieve. Where did you get the VB code from? If it's a question about how to compile VB code so that you...

Well, something has got a lock on your master database file. Maybe you or someone else are trying to open it in a text editor, for some reason? ...

Looks like you're trying to run a VB script through SSMS.

John