Viewing 15 posts - 661 through 675 (of 694 total)
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
August 4, 2008 at 10:10 am
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...
June 19, 2008 at 9:39 am
Thanks
I was hoping that someone knew of a different way.
Thanks
Andrew SQLDBA
June 17, 2008 at 3:23 pm
Thank You
This will work perfectly
Have a good one
Andrew SQLDBA
June 17, 2008 at 12:19 pm
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...
June 5, 2008 at 2:37 pm
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...
June 5, 2008 at 2:35 pm
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,...
June 5, 2008 at 10:44 am
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...
June 4, 2008 at 11:26 am
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
June 4, 2008 at 11:23 am
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...
June 2, 2008 at 10:54 am
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...
May 19, 2008 at 4:06 pm
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...
April 28, 2008 at 4:06 pm
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
April 23, 2008 at 9:45 am
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...
April 17, 2008 at 4:56 pm
Viewing 15 posts - 661 through 675 (of 694 total)