If I understand your question correctly I suspect that the options for file and filegroup backups are disabled because the database in question has only a single file and filegroup...

Not apart from losing the ability to recover from transaction logs. If you are going to be flip-floppingfrom full to simple and back again you may be making your recovery...

First if possible i would try and change the data type of that column form char to datetime so you only have to do this once - storing dates in...

You can read all about exists in BOL, but as you are asking about in the context of performance I suspect you are referring to how it compares with an...

I would put all the source code (sps, functions etc) in a source code control system with 1 sp or function etc per file and then add appropriate grant...

Any critical errors from sql server will be in the windows event log (use eventvwr) to look at it.

The SWL server log can be viewed in management studio if you...

If the database is in simple recovery model the log is effectively used in a circular fashion, and will only grow large enough to cope with the largest oncurrent...

select ...

from t

where col like '%[^0-9/]%'

Should I think do the trick.

This will give you all rows where any single character is not in the range 0-9 or /

You could certainly develop a script that would do this, but I would ask why, making every primary key an identity is not always a good thing. Certainly in some...

Not directly, you "could" use SSIS and truncate the required columns in the SIS package, but I would suggest a better approach is to extend the column in the...

I would simply use backup and restore. Assuming you take regular (say daily) production db backups you could schedule a job to restore the lastbackup to your dev db at...

I have to ask why - Sorry - but unless you have a lot more going on that cursor is costing you serious performance ....

Can you not just do:

Update producttopic...

Can you clarify in what way you believe triggers are not working properly in SQl 2K? A correctly written trigger will handle multi-row updates quite happily, but triggers are sometimes...

As the error message says, you cannot restore the log if the database is currerntly open by any users.

It would seem soneone (possibly even your own session) had the db...

I would check for the location of the system databases, specifically tempdb. It sounds like this is on the default C drive and growing with your big queries.

I would move...