Read thru the SQL BOL for anything that you need in regards to SQL. There are even tutorials. That is the best place to look for answers

Andrew SQLDBA

There really are no more system tables in SQL 2005. They are views that look at tables that users cannot see. Look under the Systems Views of the Master database

Andrew...

Thanks

I was hoping that someone knew of a different way.

Thanks

Andrew SQLDBA

Thank You

This will work perfectly

Have a good one

Andrew SQLDBA

You can also create a Maintenance Task that will do it all for you, then you can schedule it to fire off when ever you need. You could even write...

Thank You

That was silly of me to ask that. The SQL Books online explained that. I read that yesterday after being asked if I use it, but was not able...

No, should I use that?

Thanks

Andrew SQLDBA

Thanks for the advice

So why is SQL throwing this error? I need to be able to take a backup and restore the database on a different server using the commands,...

What about the Users in a specific database? What table are they stored in?

I am seeing a user that is in a database that I just restored. I need to...

Thank You

I could not think of that. Maybe it was too simple or something.

Feels like a monday after a long weekend. My brain is not working clearly

Thanks again

Andrew SQLDBA

Thanks for the reply

I have been looking at some of the scripts that I have found in other posts. However, we do not allow the use of xp_cmdshell to be...

I am curious as to why you would need an MSDN subscription to do any of that work. MSDN has nothing to do with a database.

All you need to do...

Because you should always use an ADO connection when using ASP.NET. Or you should use OLEDB connection when using classic ASP.

ODBC is old, slow, and has plenty of security...

Thanks for the info

It has been so long since I worked with multiple file groups, I wanted a second opinion before starting.

Thanks

Have a good one

Andrew SQLDBA

The account that I am using to start the service is a domain account. I cannot log in as that account. Plus, it is set as a non-human account. This...