That makes sense.

HostingLabs might accomplish what you need. If not, I'm sure you can find another. (They're just the first one that came up for me in an...

Good old fashioned useless error messages! Glad you got it fixed.

SQL Server can, depending on hardware, handle a huge number of simultaneous inserts. That's not the problem.

If the inserts were failing and being rolled back, you'd have gaps in...

You should be able to. I just use MS's update page for that kind of thing.

If you really need answers on this, please respond to my post.

Pretty much as expected.

Is the database server set up for Windows/Mixed authentication?

What application are you trying to connect from?

Are both machines (client and server) on the same domain?

myke (8/7/2008)

---

I think the most important thing, is actually doing it.

One of the biggest problems i've seen people face learning SQL is that they'll have the technical aspects nailed down...

It's going to take a call (or e-mail) to Microsoft to sort this one out.

Yeah, it all depends on the company.

There are always specific instances where the general rule doesn't apply. If you have a table where auto-generation and auto-update of statistics doesn't do what you need, then by...

SSIS can select from the system views, then do a For Each Next loop over the tables.

So, of course, can dynamic SQL.

Go with whatever you're comfortable with.

I have to say,...

This is a duplicate post. I already answered this in the Administering forum.

Please do not double-post.

Try changing this:

on profile.acct = BACKUPSQLSRV3.trading.dbo.account.acct

to:

on profile.acct = account.acct

See if that does what you need.

Last company I worked for based its time-off policy on Jan 1,...