Viewing 15 posts - 25,366 through 25,380 (of 39,804 total)
You cannot "change" a login. You will need to remove the login and then add it back as a Windows login.
January 25, 2009 at 7:20 pm
It doesn't affect logging in. It's possible that you can't access a table while the index is being rebuilt if its' the clustered index, but it should appear as a...
January 25, 2009 at 5:31 pm
It's not really clear what the error or issue is. Whatever you do with PGP, you should be able to do with the command line. Once you can execute things...
January 25, 2009 at 10:33 am
Excel automatically adjusts data types and precision to handle different values unless you set the number of decimals. SQL Server doesn't act like that. You'll get implicit conversions that might...
January 25, 2009 at 10:31 am
It was a great session with Paul and the art of negotiating is something that everyone could do better with. It is definitely important, not just for tools, but also...
January 25, 2009 at 10:26 am
Check that the services are running, check that your firewall is not preventing connections.
January 25, 2009 at 10:22 am
You should spend some time learning about SQL Server and it's structure. Look in Books Online for logical and physical architectures.
There should always be free space in the database as...
January 25, 2009 at 10:20 am
Management Studio. Unless the SQL Server instance is on your local workstation, you are always managing permissions remotely.
January 25, 2009 at 10:18 am
I'd start with Books Online and get the basics from there. They have a good overview.
We have a lot of articles here: http://www.sqlservercentral.com/Articles/clustering, and there are some good videos here...
January 25, 2009 at 10:16 am
Do you mean that if there is a quantity of 3 for the it items, you need to insert 3 rows into order details? Are these the same rows? What...
January 25, 2009 at 10:14 am
The first few queries after a reboot should have a lower ratio.
I haven't seen anything reported on this before. Do you know what the ratio was before, 91%? 95%?
January 25, 2009 at 10:11 am
some interesting replies here here. Sorry I wasn't in the discussion earlier as I was coming home from the UK.
The CLR has definitely made SQL Server a more complete platform....
January 25, 2009 at 9:56 am
I think you're on the right track here. I've never used linked servers much in environments so I'm not sure if this makes the best sense for consolidation. Things I've...
January 25, 2009 at 9:53 am
If the transaction log gets really big, it's because of activity. Changes in the database. No bugs or other things cause this to grow.
Perhaps you're rebuilding indexes? That will grow...
January 25, 2009 at 9:44 am
Has anything else changed? Is this right after a reboot or has it been continuing for some time since you installed the SP?
January 25, 2009 at 9:43 am
Viewing 15 posts - 25,366 through 25,380 (of 39,804 total)