Viewing 15 posts - 23,596 through 23,610 (of 39,944 total)
You have someone connected to the database, perhaps even you. You need to remove everyone from the database before you can restore.
June 13, 2009 at 9:35 pm
There's not enough information for us. What does a log in or log out mean? Where do you keep the data? You are getting the cartID or the sessionID, but...
June 13, 2009 at 9:29 pm
Congrats Grant and Gail as well!
I'm an alternate, fine by me. Jeff, any word for you?
June 13, 2009 at 10:03 am
OK, I have finally updated the database and corrected the question to say "SQL Server, and "unicode characters" as well as awarded points back.
My apologies for this.
June 12, 2009 at 10:47 am
No idea on security here, but we have one login for the web app, in a role, basic db security.
There are roles in the db tables, so I assume they...
June 12, 2009 at 10:43 am
you should be able to connect to 2000 from SSMS. I'm not sure about the Express version, but I wouldn't expect it to fail.
I have SSMS here, SQL 2005, SP1...
June 12, 2009 at 10:33 am
How did you define the temp table? Did you add a collation to the DDL?
June 12, 2009 at 10:05 am
I don't think you can change the priority of a single DTS process. What you can do is build checks into those processes, perhaps at places, and query to...
June 12, 2009 at 9:28 am
That's interesting. I'd say 1,000/sec is high, but that's just a guess. It's been some time since I tracked this. I ought to see what SSC does.
June 12, 2009 at 9:08 am
There's some nHibernate in use here in the admin tools. When it became problematic to add columns to a page (related table) or change the queries for particular pages, I...
June 12, 2009 at 8:35 am
You can right click on most of the folders and there is a "Generate Scripts" option for jobs, alerts, etc. You run that, then take the result and run that...
June 12, 2009 at 8:17 am
To add to Gail's note.
It looks like you have a 4:00am backup. I assume you do that once a day, with log backups taking place every hour.
If you lose the...
June 11, 2009 at 2:15 pm
You can ONLY move a table with a clustered index. You do this by rebuilding the clustered index on the new filegroup. If you don't have one, just create one...
June 11, 2009 at 2:08 pm
What is the data type of the field you are using in the WHERE clause, and what exactly is the code you are using?
Likely, as Lynn mentioned, you have an...
June 11, 2009 at 2:05 pm
I assume the domain is correct, and that you can log on locally to the VM.
Can you log on with NT Auth to (local)?
June 11, 2009 at 2:02 pm
Viewing 15 posts - 23,596 through 23,610 (of 39,944 total)