Create a stored procedure to do backups on the SQL Express server, and then execute it with SQLCMD or OSQL in a job from another server. You will have...

You cannot do that in a default, because column values are not available in a default.

Just do the conversion when you insert the data. Or don't bother creating a...

I made extensive use of stored procedures that created temporary stored procedures for reporting in a data mart application. This reason I did this was because there could be...

holly_westell (1/7/2008)

---

I have a customer who may want to introduce a SQL cluster to his environment, where one node of the cluster is in one location, and the other node...

...Michael, they already think im a SOB! haha! Actually they all think I'm overreacting. Even some of the people at my own company who have to do work...

I don't really know, but I think there may be a performance reason to do this with some versions of Oracle.

I don't think there is any good reason to do...

You should really contact an accountant about this.

If you don't set it up right, tax penalties can be quite severe.

If he has access to create the tables in tempdb, setup a job that runs ever hour or so to delete them.

When his stuff starts failing, tell him you have...

Greg Snidow (1/8/2008)

---

If I do that I get seconds...

My mistake, I didn't realize the OBJECT_ID function OBJECT_TYPE parameter was available in earlier versions of SQL Server.

I checked, and it was also available in SQL 7.0. ...

Sergiy (1/7/2008)

---

It's because undocumented parameter Jeff used.

Follow BOL prescriptions...

Jeff Moden (1/4/2008)

---

Don't use either... use the functions built for this...

1. Check if temp table exists...

IF OBJECT_ID('TempDB..#temptablename','U') IS NOT NULL

PRINT 'Table Exists'

...

create table (

[COLUMN] int not null

constraint [PRIMARY_KEY] primary key ([COLUMN])

)

You can use the output from one of these commands.

exec sp_helprotect

select * from sys.database_permissions

select * from sys.fn_builtin_permissions(DEFAULT)

It can be done by creating stored procedures that show you the security settings, and granting you access to execute those stored procedures.