Hi,

Try

http://www.connectionstrings.com/?carrier=sqlserver2005

I think you need to change source to server.

Regards,

Ian.

Hi,

Have you installed the SQL 2005 Native Client driver on your laptop ?

http://www.microsoft.com/downloads/details.aspx?FamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

That would probably account for why you can see 2000 but not 2005.

Regards,

Ian.

Hi,

The bit at the end of the code should be

AND FiyatKategorisi='''

+@ozelkategori+''''

You need the extra quotes to get...

Hi,

All you need is a slight change to your code.

select

upper(left('smith',1)) +...

Hi,

Local drives can't be declared as a cluster resource, because their not available to each node.

My cluster works OK with the tempdb on the SAN along with the rest of...

Hi,

Take the GO command out and it works perfectly (well on mine anyway).

GO Commands don't belong inside a begin - end loop.

Regards,

Ian.

Hi,

Personally I use this, which is quite similar to yours, except I have this "strange" habit of calling my cursors gerbil

This does work...

Hi,

You just need a  WITH INIT on the end of your backup line.

Regards,

Ian.

Thanks.

Thanks for that - gives me more confidence, particularly since the pervasive backend is for our payroll

Hi,

This might be of some use to you.  It' mentions how to start the server in single user mode to get in to it.

http://sqlblogcasts.com/blogs/simons/archive/2007/05/22/How-to-access-SQL-Server-when-you-ve-forget-the-password.aspx

Hi,

I would create a trigger on table1, which updates table2 using the data from the inserted table.

Inserted & Deleted tables are only available inside a trigger, for an update transaction...

Hi,

I would suggest you might wish to consider a database trigger as an alternative method for restricting who changes procedures / tables and you can use them to roll back transactions...

Hi,

Assuming your using NT / AD authentication, I would look at the users group memberships and see what permissions those groups have.

But if you create the user, with no permissions...

Hi,

SQL 2005 Enterprise Edition

Which is set as a cluster, but Reporting Services isn't cluster aware.

Thanks