Hello,

What is the Default DB set to for the Login (you can view this in the Login Properties page, from within SSMS)?

Does the Login have rights to the selected Default...

Hello,

You could do worse than to start with one of Microsoft Press’s own offerings, like “SQL Server 2005 Implementation and Maintenance” (ISBN 978-0-7356-2271-5).

Regards,

John Marsh

Hello,

What results are you getting in the Job History? Can you post a sample?

In the Advanced Settings for a Job Step there is the option to save all the step's...

Hello Again,

There are a couple of threads around (like the one below) that seem to suggest it is an issue with Windows rather than SQL permissions. Can you check an...

Hello,

Does this thread help?

http://www.codeplex.com/MSFTDBProdSamples/Thread/View.aspx?ThreadId=24515

It seems they solved the issue by running SSMS using a Windows Administrator account.

Regards,

John Marsh

PS: Nice Avatar 🙂

Hello,

Have you identified where the bottleneck is? Is it definitely the Web Server or is the SQL Server running slowly, or do you have poor connectivity between the Web and...

Hello,

If the DBM Application really must have the Sysadmin Server Role then you are in trouble.

The only glimmer of hope that I can think of, is that in general a...

Hello,

You can have multiple instances of the same version or different versions of SQL Server on one machine.

I would suggest that if your DBs need to work together e.g. one...

Hello Lidia,

I would try to analyse why previously working jobs suddenly started failing. Did anything change on the server e.g. a Service Pack was applied? Was the Account under which...

Hello Phil,

I guess it is an ASP.Net Web page? It’s been a while since I worked with them, but I would assume that in the code behind, the DataGrid’s Load...

Hello,

SSMS has Scripting tools available from the Menus. They give you the option to script the Create statements for one or many objects, depending on what context you are in.

Regards,

John...

Hello Phil,

May be you could set a default value for the ProductId or Description when the form opens, which would limit the number of finds.

Regards,

John Marsh

Hello Phil,

If nothing is being recorded by Profiler, then it sounds like the issue may be in the Application rather than in the SP.

Are you building a SQL string in...

Hello,

I’m not sure exactly what you want to do. If you want the script of a table and its indexes, constraints etc. then you can do that from SSMS. If...

Hello,

A couple of questions:-

1) What happens if you try Select * From dbo.qryTEST

I’m just wondering if there is another View of the same name in a different Schema?

2) Are you...