Viewing 15 posts - 1,381 through 1,395 (of 1,654 total)
Depending on the type of information you want there are several ways to go. If you want a message then a certain value exceeds some value you might want to look into...
February 6, 2007 at 2:34 am
I've seen that problem when kerberos authentification could not be initialized when the server starts up. Check you're 2005 SQL log for any error during start up.
Most of the time...
February 6, 2007 at 2:20 am
As Graham alrady wrote, it's the OS which determines how much memeory SQL Server Standard Edit. can use. Also on a 32-bit OS you need to use AWE and 3/gb,...
February 5, 2007 at 8:22 am
This seems to be some kind of bug and you're not the first one to encouter this.
Try the folowing:
Check if the database compatibility level is 90.
Run sp_updatestats. Statistics were invalidated...
February 5, 2007 at 3:03 am
Thomas,
I'm a bit confused. What do you mean with "a database which originally was created in the master database." You cannot create a database inside another database.
How do you restore?...
February 5, 2007 at 1:06 am
Not sure if this is the problem, but shouldn't it be DataTypeCompatibility=90 ?
Markus
February 1, 2007 at 11:27 am
Chris,
you need to register the servers. In the registered servers pane you should then see your instances.
If you don't see the registered servers pane use Ctrl+Alt+G.
Markus
February 1, 2007 at 11:23 am
Sean,
I haven't used 64-bit standard edition only Enterprise Edit.
We had no issues running it side by side with 32-bit SQL 2000, but I remember one issue with linked servers from...
February 1, 2007 at 11:19 am
Sean,
a inplace upgrade from a 32-bit Edition to a 64-bit edition is not possible. You need to install a new instance and when copy your databases, logins, jobs etc. to...
January 31, 2007 at 1:16 am
What about converting it into a XML document and when store it as xml datatype ?
Markus
January 30, 2007 at 4:07 am
Sorry but the question is about database snapshots not snapshot isolation level. and from BOL "Database snapshots are available only in the Enterprise Edition of Microsoft SQL Server 2005. "
January 30, 2007 at 4:03 am
Brij,
reading your post I wonder why you "need" to do partitioning. If your not even sure if it's benefical, why you're so sure you need it?
Trying to answer your questions
1)...
January 30, 2007 at 3:59 am
Mario
no need to worry about this. Some applications need specific cnfiguration settings. That's why they issue a sp_configure statement each time they run, just to make sure the setting is...
January 30, 2007 at 3:46 am
Chris,
before you install SQL 2005, you shuld define which parts of 2005 you will need. I did some large migrations and most of the time we choose only to install...
January 26, 2007 at 7:08 am
Mark
as far as I know this is exactly the case. Building up the grid takes a lot longer than results in text. The 3 ms is the real execution time....
January 25, 2007 at 9:20 am
Viewing 15 posts - 1,381 through 1,395 (of 1,654 total)