Viewing 15 posts - 3,391 through 3,405 (of 6,679 total)
I took a quick look at this and see several problems. However, I think the biggest problem you have is the EAV model you are working with for the...
February 11, 2011 at 2:30 pm
SKYBVI (2/9/2011)
Is BIDS installed on that server.??SSIS is a must for maintenance plans.
Regards,
Sushant
No - it is not a requirement. It is a requirement for specific versions (e.g. SQL Server...
February 10, 2011 at 2:33 pm
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...
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...
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...
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...
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...
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...
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...
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...
February 4, 2011 at 10:18 pm
Chrissy321 (2/3/2011)
February 3, 2011 at 2:05 pm
Krasavita (2/3/2011)
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,...
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...
February 2, 2011 at 8:10 pm
Viewing 15 posts - 3,391 through 3,405 (of 6,679 total)