Methinks no to the "application roles with multiple databases" question.

But you're right about it not being a good practice. But, PUBLIC role?! Be serious Mr development group...

Try:

 

DECLARE @tb char (20)

SET @tb ='ilan'



EXECUTE ('

CREATE TABLE ' + @tb + '(

[id] [int] NOT NULL ,

[Fname] [nvarchar] (50) COLLATE Hebrew_CI_AS NULL ,

[mhlka] [int]...

I suggest that, on a database by database basis, you create a role to do this. Give the role DDL privileges and backup privileges.

exec sp_addrole 'DDL_And_Backup_Role'

exec sp_addrolemember 'db_ddladmin' ,'DDL_And_Backup_Role'

GRANT...

You could also consider SQL2000's sql_variant datatype. Eg.

 

create table MyTable

    (PointValue sql_variant)



insert MyTable select 1

insert MyTable select 1.8123e3

insert MyTable select...

...but this opens up a wonderful way of restricting the use of a certain range of IDENTITY values. Take for instance:

 

create table MyTable

(id...

I've seen this before, but MS don't seem to have acknowledged it as a bug. It will happen even if you do a straight FILEGROUP backup for model from...

Dunno. All my SQL2000 is at SP3.

But, it happens on SQL7.0 too.

Cheers,

- Mark

Yes. Happens for me too. Not just for foreign keys and for other constraints as well.

Cheers,

- Mark

I beleive the solution may be the "Hide Server" option in SQL Server Network Utility (nb. NOT the client utility), TCP/IP properties.

Cheers,

- Mark

Hi Carol,

What's your question?

Also, do you really want an email for every update on the table?

How about an end of day scheduled task instead?

BTW: I dont think "orderdate LIKE getdate()"...

From the looks of it, the answer is YES.

BUT, is this database one that was created by a 3rd party and used by its app? If so, then this creation...

No.... DDL not DLL.

DDL is Data Definition Language (the creation, dropping and altering of database objects, as you've shown in your last 2 examples) and can be assigned to a...

I think you may be stuck with using a stored procedures that run sp_executesql to evaluate the string.

An ideal solution would be a function that could use sp_executesql but unfortunately...

Fingers crossed this posts ok....

http://register.microsoft.com/mswish/suggestion.asp?from=cu&fu=%2Fisapi%2Fgomscom%2Easp%3Ftarget%3D%2Fmswish%2Fthanks%2Ehtm

Cheers,

- Mark

Looks to me like a (3rd party) app is adding a bit of overhead to your SQL Server, perhaps necessarily, perhaps unnecessarily. Does the login/user under which it's running...