Sushila,

Look at it this way: sometimes creative people care only about the content, not paying attention to the form. I know it well. I had very good grades in language at...

Collect 'em all!

I personally collect commercials. The last one yesterday:

"People prefer us, Wireless because of the big Network..."

Some creators of radio commercials do not realise that a spoken word does not...

This English!

And on the top of everything, "we aren't know any programin'... ", aren't we?

This is an international site. A lot of participants speak imperfect English, but they are...

Hello Yuri,

There was a good article here on this site at the end of September:

http://www.sqlservercentral.com/columnists/rVasant/manipulatingtextvariables.asp

Manipulating Text Columns

by Raj Vasant

I saved this article in my Virtual Briefcase, it explains a lot...

This is certainly a descriptive error message (did you remember this joke about the young man who writes error messages for Microsoft?)

The SQL Agent error message on startup is OK,...

Jeff,

Lets start with startup.

1.Get us any messages after the server is coming up from application, security and system logs that are errors or warnings. The moment the server is coming...

Hello,

It is not posiible.

You can implement a sort-of solution by using Application Role but you still have sysadmins on the server, SA for example. Additionally you will have an application...

I answered correctly but I wonder if the answer with "The process works normally but produces an error message" could be implemented? Something like in the trigger text:

Begin Transaction

<update statements>

RAISEERROR...

Each server must have a DBA or a System Admin or Application Admin, the person responsible for a particluar server and what is running on it.

Contact key people for each...

Nigel,

DTSRUN is a command-line utility. One of the parameters is

/E Specifies a trusted connection (password not required).

So yes, integrated authentication can be used.

For named Pipes to be used...

I never had to reinstall SQL Server when changing domains.

In my experience the following may happen when the machine name stays the same but domain changes:

1. JOBS !!!! if the...

There are 2 kinds of applications: home-grown and vendor's

For the home-grown applications you would know the technologies that are used: ASP or ASP.NET, VB, C++, C##, MS ACCESS , SQL...

Burt,

You say: "I can say when I query the information via T-SQL it takes seconds, but displaying the information via web, it takes say 30 seconds..."

I have a feel that...

It happens more often then you think. In most of the enterprises Data Centers are locked and servers are accessed in Terminal Services remote Administration mode. That is when it...

Greg,

They usually call you in a couple of days complaining that SA password does not work for them anymore... Nice way to find out who actually is using it. Also...