I can't get performance collector to work and am hoping that microsoft are going to send me a beta release which fixes the locale problem.

Additionally the sqlh2 /DDMY will only...

in case anyone else encounters this error.

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

yes I do, I'm sa and can make changes in query analyzer it would appear that I can't make changes via em wherever it may be installed.

Also, I've just right...

All of these settings appear to be OK or certainly as for other servers with which I don't have a problem.  Also, the problem also occurs when logged on to...

Thanks for your reply...

Timeouts are as for any other server.  TCP/IP is there. Tried connecting by IP but same problem.  Subnet is correct. IP is static.

This happens locally on the...

Just a thought but have you tried an access project rather than an .mdb?

Smaller footprint and quicker than a straight database.

I believe that you can only restore master to the same location.

Hope this helps.

My understanding:

The default of owner dbo only works for those with sysadmin.

Others that can create object have to qualify the name with dbo.new_object_name.

HTH

There are a couple of scripts on the site that do this, try ...

http://www.sqlservercentral.com/scripts/contributions/565.asp

http://www.sqlservercentral.com/scripts/contributions/511.asp

I'm struggling with this at the moment and so thought I would share in my confusion ...

I think I have found that with sp's the default is that the users...

Hi,

As I understand it then you can't do this. Deleting the file deletes all of its contents.

If you use a query statement in DTS rather than copying the object you could use top n to control the number of rows you are returning.

Have a look at...

I had a similar problem and the same discussion. In the end I reached a compromise which was to take away the use of sa by changing the password...

AS far as I know the restore history is in msdb and you can restore this from backup to a different database name - just so you can get at...

Thanks for your suggestions but I haven't got anywhere. I have scrapped the box and started again - well at least the backups worked OK but now perhaps I...