The tag has no wiki summary.

learn more… | top users | synonyms (1)

3
votes
2answers
774 views

SQL Server Management Studio not scripting all objects

i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the ...
1
vote
3answers
8k views

Can I change a live SQL Database from Autogrow safely?

I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA. The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to ...
1
vote
1answer
118 views

Removed SQLServerAgent account What should I do ?

I have removed by accident SQLServerAgent account and now I cant get access to the database. Connecting from management studio throws me error 26 and system log shows: SQLServerAgent could not be ...
1
vote
3answers
706 views

Sql Server management studio 2005 cant connect to localhost using windows authentication

I am trying to localhost using windows authentication with SQL Server management studio and I am getting a message that "Login failed for user..." (Error 18456). I made sure that all the services are ...
1
vote
2answers
1k views

Add conditions to maintenance plan sequence on SQL Server

I would like to add a condition to a sequence in my SQL Server 2008 Maintenance Plan. This condition is based on the variable set by a T-SQL Statement Task: declare @primary bit = 0 select @primary=1 ...