I believe you can use a comma to specify the server.

So for the sales server here: sales.sqlservercentral.com, 1899

would connect on port 1899.

What doesn't work? By that I mean what behavior is occurring. The trigger looks fine syntactically, but it won't work if multiple rows are updated.

Instead what you'd do is join...

You need to set up logging in the maintance plan, then check the text files that are created. They will have more details about what is wrong.

Thanks for the update.

I won't lock the topic, as someone might see something you could do better, but it's good to know what fixed it for you.

The server may slow down with SHRINKFILE, so be aware of that. You might be better off resizing the files, or if they were small and grew, just restarting the...

I would encourage you to give a hint and ask them to try to answer the question, even the PhD candidate.

I usually post" We are happy to help, but we...

Images have been loaded.

Blogs could be a detractor, but they also show you learning, or trying to learn. The fact that you've repeated a "myth" doesn't necessarily mean you're a bad employee. It...

I also can't see the government getting involved in vendor level certifications, providing the opportunity is there equally for all groups.

I tend to agree with you, Lynn. I think we ought to have a path of certifications that go from the basic to intermediate, to the advanced Master/Ranger program. It...

With Access they've tried, and you can set up essentially the Express engine for Access apps.

I think we are getting closer with Exchange, but I'd like to see the specific...

The script is a T-SQL script. You need to execute it in SSMS.

Gail's design shows why it's better for you to give us the information about what the entity is, and what the data is represents. A good designer will consider that...

The conversion time is hard to guess. It's a "build a new table, copy all data from the old one". You can test that with a fake table.

As far as...

Probably could, and should.