Viewing 15 posts - 6,151 through 6,165 (of 6,676 total)
On SQL Server 2005 and greater, you can right-click on the database in Object Explorer, select reports, standard reports and run the disk usage by tables report. There are...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 9:21 pm
ALTER DATABASE database SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE....
ALTER DATABASE database SET MULTI_USER;
I use the above to refresh my training environments every day.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 9:06 pm
Lookup ISNULL and COALESCE in Books Online.
SELECT COALESCE(column, '') AS column;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 8:45 pm
Yes, you can attach documents. Scroll down further and you will see a button to Edit Attachments.
The errors you are getting show that you have a problem with WMI...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 8:42 pm
I really don't know what else to tell you. In Object Explorer - what is the actual name of the server you are connected to?
Does it match the name...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 7:46 pm
Not sure if that would have fixed your problem with Workgroup edition - just something I remember having to do with multiple instances.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 2:04 pm
GSquared (8/14/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 1:44 pm
BTW - reviewing the summary will show you that this server does not have the database engine installed.
Time: 08/13/2008 08:59:36.608
KB Number: KB921896
Machine: DPPSQL5
OS Version: Microsoft Windows Server 2003 family, Enterprise...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 12:58 pm
Okay, let's go all the way back to the beginning. Where are you seeing that the version is 9.0.1399 (RTM)?
If this is in Help | About for SSMS -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2008 at 12:51 pm
Not sure about why those options are greyed out. Normally, I see those options greyed out when I have the server setup in the registered servers list, but can't...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2008 at 10:57 pm
Keith Knox (8/13/2008)
Check Database IntegrityReorganize Index
Rebuild Index
Update Statistics
Clean Up History
Back Up Database (Full)
Maintenance Cleanup Task
You do not need to reorganize and rebuild your indexes. Pick one of them -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2008 at 2:06 pm
Jack Corbett (8/13/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2008 at 1:15 pm
When you RDP into the server with the SQL Server name - do you connect to a machine with a different name? For example, if you RDP to a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2008 at 9:52 am
Manosh (8/13/2008)
Both solutions are working.. Never read about "coalesce". Reading more about it now. Thanks for introducing a new command.
You are welcome 🙂
COALESCE is the ANSI standard version of ISNULL....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2008 at 9:42 am
Andy Warren (8/13/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2008 at 9:32 am
Viewing 15 posts - 6,151 through 6,165 (of 6,676 total)