Viewing 15 posts - 30,361 through 30,375 (of 39,758 total)
You can query for the licensing mode: http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
I'm not sure why the product key was filled in. Possibly someone set up an unattended install and burned that to the media....
December 10, 2007 at 1:30 pm
Do you get a similar error in the SQL Server error log?
This can happen at times when the server becomes overloaded. Is this standard edition of SQL Server? The reason...
December 10, 2007 at 1:26 pm
Can you explain what isn't working in the backup and restore? This is a lot to look through and I don't see anything obvious. Does it not perform the log...
December 10, 2007 at 1:21 pm
I would agree with Michael above. You should not change MAXDOP or depend on any ordering of the records for any reason. It isn't the way SQL is designed to...
December 10, 2007 at 1:18 pm
Or build dynamic SQL. For a case like this (CREATE DATABASE command), I wouldn't worry about any performance issues.
December 10, 2007 at 1:17 pm
What is the report doing? Can you run Profiler and try to determine if this is a problem with the db engine or SSRS?
December 10, 2007 at 1:16 pm
If this is important, production data, call PSS at Microsoft.
DO NOT RUN ALLOW_DATA_LOSS as it's behavior is unpredictable and does not necessarily help.
This is a complex issue, and we can't...
December 10, 2007 at 10:41 am
The DTA is not bad, but it depends on the workload you run through it. Like any tool, it's examining the queries and making guesses. You want to be sure...
December 10, 2007 at 10:39 am
Rudy,
Have to disagree with you there. I think trust is important because it comes from someone being professional in their job. Process and procedures are the same way. There are...
December 10, 2007 at 8:41 am
That appears to be the case here as well. I can use indexing to move the tables to new filegroups, but can't move metadata. Can't use DBCC to get things...
December 10, 2007 at 8:37 am
EMPTYFILE should work for NDFs, but not sure it works in MDFs. I thought that error'd out because you can't remove an MDF, nor create a 2nd.
Hmmm, guess I need...
December 10, 2007 at 7:38 am
Once you save the maintenance plan, open it again by double clicking it. You will get a "toolbox" in the lower left.
The History Cleanup task deletes meta data in the...
December 10, 2007 at 7:35 am
How is it updating? Is it doing a transformation? Is it an Execute SQL task? You haven't really explained how it works.
If it's just using SQL, why not use a...
December 10, 2007 at 7:31 am
Don't think the above will move the mdf. Will get the data and objects out, but system tables, metadata, etc. are stuck until you detach/attach.
December 10, 2007 at 7:29 am
Viewing 15 posts - 30,361 through 30,375 (of 39,758 total)