Thank you!

Assigning GetDate() to a DATETIME variable works, but GETDATE() returns a DATETIME datatype, so why doesn't passing it as a parameter directly work ?

Hi,

depending how long your queries on the linked Oracle server take, it might be worth having a look at the properties of your SQL server in EM, on the connections tab look...

Hi,

Yes...

About 12 years ago I joined a small contact management company. I didn't know they were struggling when I joined, but apparently they had lost a lot of money on...

I am the only person here who manages this server, and I haven't attempted to rename it. The server seems to be running OK , and I don't use @@servername...

Are these messages coming from the DELETE operation itself rather than the trigger. What happens if you SET NOCOUNT ON in the QA environment and then delete records?

I guess...

Hi Frances,

what was the failure message you received please? If your job step is using email then check that the email account is still accessible to the stored procedure.

David

When you access the other server directly from QA, are you using Windows authentication or a SQL Server login and password?

If you use a login and password to access the...

Hi,

If the database file is really large then the time taken to grow it by 5% may not be quick enough to keep up with the demands of the data....

Best manager I ever worked for was a guy called Andy, when I was working as Analyst/programmer in a public sector institution. Andy could talk authoratively on every subject from...

Here is a really feeble friday afternoon starter for 10...

If you only had two features, then you could create a cross join between two...

Another random thought, you say SQL Server is already 'uninstalled', are you implying that it was previously installed and you are re-installing to the same path.

Maybe your registry got chewed...

Hi,

A random thought occurred to me. Is the limitation of 35 characters on just the directory name where SQL server is installed?

I remember in a recent install picking a...

I was just wondering, can compliant75pctRule contain NULL?

Because if it is a mandatory NOT NULL then presumably all the rows will be either T or F, so the CASE...

Hi

Not really an expert on this sort of thing, but since no-one has responded and everyone else but the poor DBA is at the Xmas do...

An upgrade to SP4 probably...

Scuba diving.

Why miss out on the other 7 tenths of the planet and the animals and plants that live there?

Floating along weightless with a camera 15m down in a...