You run the following query.

sp_configure 'show advanced options', 1

GO

RECONFIGURE with override

GO

sp_configure 'max worker threads', 512

GO

RECONFIGURE with override

GO

EXEC sp_configure

You didn't get the value since you have used reconfigure statement. If you...

You can create triggers to alert you when a login is created.

You have scheduled the backup to happen in a shared folder \\PO0063\E_Temp\, check whether you have sufficient freespace or quotas on the shared folder.

Refer the below link reg file movement...

By scripting the database with default parameter you will get the database structure and not with the data's. If you need with data you should specify while scripting the db.

Its...

In SQL Server 2005, if the concurrent job exec reached maximum because so many jobs are running, then any jobs that are requested to start will be queued, and the...

I think you can change the concurrent job exec on sqlagent.

Pls refer

http://support.microsoft.com/kb/306457

But b4 proceeding pls take a backup of your registry.

Change the job step to use DTSrun utility to execute the DTS package.

Refer Link http://msdn2.microsoft.com/En-US/library/aa224467(SQL.80).aspx

I think this would help you.

Are you xp_cmdshell, if yes check whether the service account has following privileges under User rights assignment on Local security policy.

1.) Act as a part of operating system

2.) Replace process...

Hi Sugesh,

Thx for the reply, try creating a db named as the instance for eg. if your instance is sugesh then name the db as sugesh_test or sugesh1 etc and...

I dont have alias created under different names.. if you connect as servername\sqlxxxx (replace xxxx with any character) its getting connected to the server

You can refer to the following post. we have discussed abt the same topic over there.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=368205

You can go to the following path in registry to change the directories.

Type regedit.exe in Run and press enter

Expand to:

HKEY_CURRENT_USERS\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

In the right pane, you will have the...

If you are using Sql server 2000, then got to CONTROL PANEL, you can see 'SQL server 2000 Licensing setup'. I think it will provide you info reg licensing.

Wat's the default db for the login? does the login have necessary privilege on default db?

Hi,

You can refer to the following link, which will provide some ideas about ODBC.

http://www.microsoft.com/technet/prodtechnol/sql/70/proddocs/diag/part2/75528c10.mspx?mfr=true

http://support.microsoft.com/kb/135533

Regards...Vidhya Sagar