We had hundreds of instances at JD Edwards, and make regular efforts to consolidate things. We did not take a "everything should be consolidated approach", but rather identified underused instances,...

The client can't be that picky if they hired this recruiter. Talk about poor communication....

#1 - silly argument. SQL Server is built for this. On any modern network the time is trivial between the server and client. plus, local databases are accessed the...

You will need to detach the databases, script the logins, and install Standard. You can attach the databases (same structure) and run the logins. sp_change_users_login can help you sync things.

I second GSquared's note. I've typically done this so the code is easier to read. Same var name in calling batch as in the proc.

The insert trigger will run after the insert from ADO.NET and then examine the table. The new rows will be in the "inserted" virtual table and you can use an...

As Gail mentioned, we'd be happy to help you understand the SQL, but we'd like to see what code you've written. What don't you understand, or what is the code...

you've asked an incredibly open-ended question here. Really if you aren't sure of how to set this up, you need to pay for consulting. This is really beyond the scope...

Dan, you're welcome, but I had little to do with this. Someone else dropped it in there. I have written a few, but my knowledge of spatial data is low.

If...

Feel free to ignore questions that don't apply to you.

Should we not ask questions on Service Broker because few of you use it? Or skip replication because it's not...

Wow, are the CUs classified as critical? I didn't think that applied to most of them.

Thanks for the kind words.

That might be true, though I don't think the Event Viewer actually queries for more up to date info. It would be good if you could allow queries to MS...

Alvin,

That was good 😛

It's a bit of trivia related to spatial information. If you work with data on the oceans, this can be valuable. It's not something most of us will deal with,...

I think you're mis-reading me a little. I said that I'd like to see the user informed that there is a patch available. There's no shortcut here of not testing,...