Viewing 15 posts - 1 through 15 (of 28 total)
Just curiuos if anyone is using this? I'm planning to implement this at a disaster recovery site. On our live SQL Server we back up the db and...
June 11, 2008 at 9:09 am
Do you realize that you are in the SQL 2005 Admin forum? That KB only applies to SQL 2000.
Matt
November 14, 2006 at 9:21 am
The active connections to these databases only occur maybe once or twice a day and so far, I haven't seen any long running transactions.
November 13, 2006 at 8:21 am
Management Studio Express is the free tool that MS supplied to work with SQL Server Express.
Management Studio is the tool that comes with the other editions of SQL...
November 10, 2006 at 12:07 pm
Windows Server 2003 Std limits you to 4 GB of RAM.
Enterprise Edition allows up to 32 GB of RAM for 32-bit OS.
Datacenter Edition allows up to 128 GB of RAM...
October 4, 2006 at 10:11 am
Of course it would work the second time.
The issue is that the first time you run this process it tries to create the user and then the login. The...
September 27, 2006 at 9:44 am
It's just that you can't configure the cleanup in the Wizard. If you manually create or edit a plan created by a wizard, you can add the cleanup task to...
May 18, 2006 at 9:21 am
The login objects is selected.
The order in the log appears to be like this:
copy database
attach database
create user
create login
But the weird thing is that this works if it is...
May 18, 2006 at 8:57 am
I had a consistency error that we couldn't figure out recently (actually I'll be posting on that soon), but I did a 'dbcc checkdb (tablename, REPAIR_ALLOW_DATA_LOSS)' and it resolved the...
March 23, 2006 at 9:42 am
I didn't restart the SQL Agent after configuring Database Mail with the 32-bit version. Maybe that only affects the 64-bit version.
What threw me, was that after I...
March 17, 2006 at 10:09 am
I was using the 32-bit version.
I did figure out my problem. When you Manage Profile Security (righ-click Database Mail and choose Configure Database Mail), you can set...
March 17, 2006 at 9:16 am
This may be a stupid questions, but if log shipping and clustering are built into SQL Server, why would you purchase a 3rd Party App to accomplish that? What are...
February 9, 2006 at 12:05 pm
1. SQL Server 2000
2. 'Cannot locate or connect to SQL Server...'
3. Default instance
4. Local user and domain user are using the same BDE setup. Entered Database name and database...
February 7, 2006 at 3:40 pm
Yes, ADO works w/ SQL Authentication when logged in with a local acct.
And ODBC works w/ SQL Authentication when logged in with a local acct.
BDE is...
February 6, 2006 at 2:35 pm
Viewing 15 posts - 1 through 15 (of 28 total)