Viewing 15 posts - 5,536 through 5,550 (of 6,678 total)
John (3/23/2009)
March 23, 2009 at 10:00 am
If disk-space isn't as big an issue, and 1 hour data-loss is acceptable, is it worth simply just running a differential backup every hour and leaving it at that?
We...
March 23, 2009 at 9:51 am
steve dassin (3/22/2009)
--------------------------------------------------------------------------------
I'm not saying sql is flawed. I'm saying sql is flawed when it comes to application development.
I hear this from lots of people and I ask them the...
March 22, 2009 at 7:30 pm
JamesNZ (3/22/2009)
March 22, 2009 at 6:43 pm
In addition to what Mohit has stated, each server you have open in Object Explorer will be a connection in Activity Monitor.
You also will get a connection if you have...
March 22, 2009 at 6:22 pm
Did you change the server name?
Do you backup to a network share that is no longer available?
Can you open the maintenance plans and verify the connection and setup for each...
March 22, 2009 at 2:33 pm
You can provide the default connection information:
ssms -S.\InstanceName -E {filename}
But, I don't know of any way to open a file disconnected unless you use the functionality available in SSMS to...
March 22, 2009 at 2:21 pm
Attaching a SQL Server 2000 database to 2005 does not change tables from user to system. How are you determining that your tables are now marked as system tables?
Run...
March 20, 2009 at 5:21 pm
Are you aware of the fact that all of the SQL Server specific perfmon counters are already available from SQL Server?
SELECT *
FROM sys.dm_os_performance_counters;
If you need to be...
March 20, 2009 at 5:13 pm
Unfortunately, you are going to have to recreate the plans. BTW - do you realize that you have probably already spent more time on trying to fix these than...
March 18, 2009 at 7:46 pm
Okay - I have to ask, but have you restarted the server since adding the switch to the boot.ini? Have you put the server under enough load to use...
March 18, 2009 at 7:43 pm
dave b (3/18/2009)
March 18, 2009 at 5:04 pm
INSERT INTO Category (CategoryTypeID, ParentID, Description, HasRelation)
SELECT DISTINCT
1 As CategoryTypeID
,Category.GenCategoryID Ad ParentID
...
March 17, 2009 at 4:26 pm
It is much easier to recreate the plans, but - there is one option that I know of that may fix the problem.
Open BIDS and create a new Integration Services...
March 16, 2009 at 5:32 pm
Michael Valentine Jones (3/16/2009)
Are you completely reloading the table each time, or just adding new rows to existing data?
Dangit - should have thought about that question myself. 🙂
However, I...
March 16, 2009 at 4:12 pm
Viewing 15 posts - 5,536 through 5,550 (of 6,678 total)