Hi,

my system uses a third-party application to access and update the data. I write as much of the business logic as I can in SQLServer as SPs and UDFs. Recently...

Hi,

I may have missed something, but I am wondering why you are using a temporary table rather than a variable to hold the maximum sequence value?

You can use a...

Hi Hans,

If seems that Babelfish is not a perfect translator, it produced a sort of Spenglish (...mall pillows of discs...?) which certainly brightened a dull Sunday in operations

Any object created by a login with the server role 'System Administrators' will belong to the dbo schema.

However, you may not want to give your user this role!

BOL says...

"The dbo...

Did you try the troubleshooting tips and suggestions on the Access is Denied page, they specifically mention hotmail?

David

Hi Ramsfield,

I suspect this might be a permissions issue as well.

The error message you quote looks like the one for the Job rather than for step 1. If you tick the...

Hi,

I was wondering if this is a security issue. I looked in BOL but couldn't find any information regarding the security context in which a trigger operates, so perhaps I...

Hi there,

being a GUI sort of person , I would probably use the DTS export wizard in EM, select the Copy Objects and Data...

Hi Michael,

thank you for that timely advice. Having taken some backups of the databases to another server, I rebooted the server, finding that Windows 2000 had automatically scheduled a chkdsk...

Merry Christmas from the UK as well!

For Christmas I am going to a remote island on the other side of the world, where there are no mobile phones, and just...

I wonder if the problem is revealed by the first and last of these error messages .

Could not connect because the maximum number of '4' user connections has already...

I suspect you could use xp_cmdshell  and the net start <servicename> command, although I haven't tried it. You could use net stop <servicename> to stop the service afterwards. Alternatively you could...

Thanks for all your help folks, I will try Bert's suggestion of a UDF version of GetDate()

Merry Christmas

David

Hi,

We have six or seven databases running and use two separate SCSI disk controllers and three logical drives.

Controller 1 has:

Drive1: Operating System and Software, and backup repository on two mirrored 80gb drives

Drive2:...

PerfMon has a Transactions/sec count in the SQLServer : Databases object, you can log a total or by database.

David