Thanks, that aught to do it! I'll post the result here when I'm finished.

Max

SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

joined into the recordset above would, for example, be the perfect solution, but I still don't know how.

How does sql server display the foreign key name and the related...

There's quite a good column just released dealing with this:

http://www.sqlservercentral.com/columnists/mnash/monitoringdriveanddatabasefreespace.asp

Just copy out the script Step 1 to 4 and then SELECT * FROM DrvSpace

Max

I think, to circumvent the issue, unless you consider the following:

 - system objects

 - fixed length data types

that no fragmentation should occur in the database by adding columns to the table.

Remember as well...

Antares,

I've got some questions that I hope you'll be able to answer:

 - why was the QA temp file stored under the users domain profile on the db server?

 - is...

You've unioned the data which, if you want to return a dataset, is the right thing to do. If you wanted a summation of the data you have to sum...

DATEADD(d, -14, DateDepart) is preferable

DateDepart - 14 also works

and dates are integers

run the script to reporduce your error, after you've run the script the first time uncomment the last...

Thanks Yelena, the problem was indeed that the default dbid in sysxlogins was incorrect.

What I don't understand is that the developer said he restored the test db from a backup...

hmm, that's precisely what I had in mind...

Thanks for your suggestion, I reckon I'll try it first thing monday morning.

Have a great weekend

Max

Thanks for your replies

The mdf name is different but the database name is the same. I've tried changing the default database for...

Hi Bill

The error message:

Unable to connect to server TestServer

Server: Msg 4064, Level 16, State 1

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default database. Login failed.

The BUILTIN\ADMINISTRATOR login does exist and...

Thanks SQLBill, thanks chaps, I was unaware that SQL "compiled" a formula in a particular order.

BODMAS basics:

http://www.easymaths.com/What_on_earth_is_Bodmas.htm

Max

I can't find the reason why sql calculates the values like this, does anyone have some documentation (or was I asleep for this module???).

DECLARE @Total numeric -- or int, decimal and...

you may have to restart the sql server service, to show/commit the changes after dbcc shrinkfile, don't ask me why

p.s. the 10 in "DBCC SHRINKFILE('<logfilename>', 10)" refers to the size...

It looks like you don't have a password for SA.

Have you started the SQL Server service? You may have to do this manually the first time for your control panel...