could you please tell me how to give execute permissions to a stored procedure from Enterprise manager(GUI). I created a login abc with default database master and I need to...

What is the Migration Assistantant to run?

thanks

@command = N'dtsrun /S ABC /E /N agent_import /A gstrServer:8=ABC /A gstrClient:8=CF /A gstrEnvironment:8=QA /A gstrPath:8="d:\"', @database_name = N'', @server = N'', @database_user_name = N'', @subsystem = N'CmdExec'

In...

Could you please provide me the final script that will rebuild indexes in all the databases sothat I can create a job and schedule it.

Thanks

I just want to make sure that Shoud I need to change the servername from ABC to XYZ\ins1 or XYZ in the below statements. In the sql 2005, I have...

Thanks,

We will convert the DTS to SSIS later but right now we are going with the same dts to run in sql 2005.

We are succesfully moved to sql 2005 by...

Hi,

Could you please shed some light on this topic.I spoke to our system admin regarding this password issue and he is confident that the password meets the windows policy.Before opening...

SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet Windows policy requirements because it is too short... To continue, correct...

As I know..you need to install Integration services to use maintenance plans in sql server 2005.

When I tried to create maintenance plans without installing integration services I got many issues.After...

Hi,

I did not solve this issue so far. I want to make sure that the password, we need to give in the setup installation page is Servis Account->Use a domain...

actually, the 2000 servers are not clustered.But now we are going for cluster environment for sql server 2005. So we need to use side-by-side only. Is there any document for...

If it is on the same box, then named instance(not possible to go for default 2005 instance) and if it is new box, we can have the sql server 2005...

thanks Gail,

In general, the reason for getting these kind of inconsistency in internal operation, tell me whether the following settings be the root cause:

1.SQL Server configuration: We have sql server...

Hi,

The seql server version:

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

Feb 10 2007 00:59:02

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

We...

Hi,

In our 3 node a/a/p cluster on node 3 we 4 instances. In this case, to set Max n Min values what should i consider?

We have 16GB memeory and 2GB...