Viewing 15 posts - 3,391 through 3,405 (of 6,676 total)
The only way I know of doing this is to create a client alias on every machine that will be connecting to that instance of SQL Server.
If this is 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
February 8, 2011 at 7:34 pm
I know of several organizations that schedule maintenance quarterly, or yearly, or somewhere in between. Part of that scheduled maintenance would be index rebuilds, etc...
Honestly, if this was my...
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
February 8, 2011 at 2:56 pm
You need to verify the version of your client tools, and the version you are running on the server. Both need to be at least 9.00.3054 or greater (SP2...
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
February 8, 2011 at 2:40 pm
You posted this in the SQL Server 2005 forum, so I am going to assume you are running SQL Server 2005 Express Edition.
Please verify the edition of SQL Server you...
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
February 7, 2011 at 5:03 pm
You are running the RTM version - which had several issues with maintenance plans that have been fixed in later service packs.
Additionally, in this version you are required to have...
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
February 6, 2011 at 9:24 am
This solution will definitely work for reporting - however, you need to make sure you are running Enterprise Edition since snapshots are not possible in Standard.
Also, if you plan on...
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
February 6, 2011 at 9:20 am
You cannot run an interactive command using xp_cmdshell. An interactive command requires someone to have access to the machine where the command is being run to interact with command...
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
February 5, 2011 at 9:45 am
If you want to grant execute to all stored procedures in a particular schema, you can do the following:
GRANT EXECUTE ON SCHEMA::{schema} TO {user/role};
Advantage to this is new procedures created...
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
February 4, 2011 at 10:18 pm
Chrissy321 (2/3/2011)
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
February 3, 2011 at 2:05 pm
Krasavita (2/3/2011)
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
February 3, 2011 at 1:56 pm
You can rename the file using ALTER DATABASE ... MODIFY FILE (...). Lookup the exact syntax in Books Online.
Once you have done that, then you take the database offline,...
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
February 3, 2011 at 1:51 pm
If you need more disk space, then you need to get more disk space. Shrinking databases to try and manage this is just asking for more troubles.
What happens when...
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
February 2, 2011 at 8:10 pm
drawlings (2/2/2011)
>1- Share load of one single large DB with high transaction rate on multiple servers?Oracle RAC
Or - Intersystems Cache on a VMS cluster. 🙂
>2- Share multiple related DBs load...
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
February 2, 2011 at 2:23 pm
NJ-DBA (2/2/2011)
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
February 2, 2011 at 2:20 pm
atsql (2/2/2011)
DB should get free space of 35 GB. Current DB size is ~80 GB. Free disk space is 129...
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
February 2, 2011 at 2:07 pm
Viewing 15 posts - 3,391 through 3,405 (of 6,676 total)