I second Gail's advice. This is a bad idea, and can cause problems if there are hiccups. It is not worth it, IMHO.

I would second homebrew01's method. That is a good way to get this saved as a job/script and learn something.

What do you mean "novell"? Do you have an NDS authentication scheme?

If you can authenticate with Windows, you can add a login to SQL Server Express suing Windows authentication, and...

You absolutely have to protect the data, which means many things.

However I'm not sure you need to move it all into SQL Server databases. What you should do is help...

spinach fritatta

You might be surprised. No one in the US thought they would work, but even small cities have gotten 60-80 people to come out for a Sat. Often we use...

ALTER DATABASE command to set to online mode.

http://msdn.microsoft.com/en-US/library/ms174269%28v=SQL.90%29.aspx

BTW, any of you regulars need an MSDN 2010 subscription? Got a few in the mail. 12 month for dev/test, includes Office 2010.

PM me if you're interested.

A full day pre-con is 6 hours. Not a huge stretch if you've done 4, could be hard if you've never done more than 2. However, if you want, I'd...

The packages are stored in msdb, just like jobs, so they'll be there.

However, if you have coded in a server name instead of (local) or 127.0.0.1, then they might need...

I agree with you Jeff. We could only pick from what was submitted, but some of the feedback that I've given is that we ought to be able to review...

How's this:

select

Fname

, LName

, Mname

from Employee e

LEFT OUTER JOIN Timekeep t

ON e.employee.id = t.timekeep.id

WHERE t.dept <> 'TRY'...

It's a hard problem. Master Data Services are supposed to solve a small part of this in 2008 R2, but really just for data.

For the tables, I can't think of...

You can use sa to connect, or the DAC if it's enabled.

There's also this: http://technet.microsoft.com/en-us/library/dd207004.aspx

The problem is how do they know what fields are out there? What if they need more fields? Do they need to add them to your master table first? Is...