Remember we are not sitting behind you, looking over your shoulder.

i have no idea what is working or not working.

If you want help with...

interview questions?

your table needs to use nvarchar and not varchar fields to hold unicode data.

in addition, any parameters you are using also need to be nvarchar...so in .NET language, for example...

Ive never seen that in the options no.

You can do a find and replace very easy though

[INSERT INTO ] --> [INSERT INTO MYDB.]

i missed the part about restoring on the remote server.

if you have a linked server, i know you can do EXECUTE AT;

here's an example of creating a table on the...

just about everything is an option when it comes to scripting.

in SQL2008 SSMS, go to Tools>>Options>>expand SQL Server Object Explorer>>Scripting.

one of the options is "Script USE <database>

in your case,...

just double checked, and i can create default constraints, but no check constraints on a table variable:

declare @mytable table

(id int identity(1,1) not null primary key,

name varchar(30) unique,

employee char(1) default...

you can use a UNC path, assuming permissions for the network are in place:

RESTORE DATABASE MyDatabase FROM DISK='\\LOWELLSMACHINE\c$\SQLBackups\2008Backups\MyDatabase.bak'

for table variables, you can create unique constraints, but you cannot name them.

i don't think they allow default or check constraints either.

only temp tables or regular tables will allow a...

sqlfriends (4/18/2013)

---

Thanks, tried to add filter with where studentID=.. and schoolyear=.. this time it uses the index seek.

The reason I asked this is because we have a view that is...

you don't have to have a local smtp server; anyones mail server will do, including google, comcast or whoever you have an email account with.;

I've set up google gmail ...

as an aside, I have not gotten a linked server for access to work in SQL 64 bit / any version; against either a .mdb or .accdb

i can get...

1. Don't uninstall and then reinstall. that's not going to help resolve the issue, even though it "seems" to.

2. we really need the exact error you get. that tells us...

there is an ISDATE function in SQL as well;

here's an example base don your post:

/*

/*

Eid Variable Date? Converted?

---- --------- ----------- -----------------------

1 ...

Markus (4/17/2013)

---

Great idea. I recreated the audit table just how you described and it works for inserts and updates.

However, I have the trigger selecting the first column in the...