Don't know if it's publicly available, but I remember a free tool from Microsoft named Filltabl.exe. You might find it somewhere. You actually have if, when you own a copy...

That's very good of you

but its getting changed to datepart(year,getdate())

What's so stupid about this???

SET NOCOUNT ON
CREATE TABLE year_t
(
year_now INT DEFAULT DATEPART(year,GETDATE())
)
INSERT INTO year_t DEFAULT VALUES
SELECT * FROM year_t
DROP TABLE year_t
SET NOCOUNT OFF


year_now ...

Mike,

you can use HTML tags even in your autosignature!

Makes it easier for people to visit your website

Just to add to Antares, you might find this document interesting.

HTH

David mentioned several places.

I'd like to add this site.

But don't forget, you can try to tune your server as you like, when your schemas are poor, all the tuning...

Mark,

you didn't mention that xp_regread is undocumented and therefore the use should be considered carefully

Rather than doing this from within SQL Server, I...

One might consider having a look at

INDEXPROPERTY(...,'IsUnique')

Just for completeness, sp_help returns also informations when a table contains such a column.

Sometimes something like this can be useful:

CREATE TABLE ID_T
(
id INT IDENTITY
)
INSERT INTO ID_T DEFAULT VALUES
INSERT INTO ID_T DEFAULT VALUES
SELECT IDENTITYCOL FROM ID_T
DROP TABLE ID_T

(1 row(s) affected)


(1 row(s) affected)

id ...

You don't have backups, allow a developer to have such privileges...Do you also overclock your server?

Sorry, but I guess, you're pretty much out...

Behold, that would mean spending the whole day with the kids! No, no

I just discovered, that posting to the german SQL...

Hi Dave,

long time, no see

Knew there was a way without convert but could not remember it

Showing your age?

Well,... not here

But that would mean giving the user the right to run any SELECT statement they wanted. I only want them to be able to run the sp. Is it possible...