rockingadmin (10/16/2009)

---

Actually, i want to close the connections who are connected for long hours and their status is sleeping. because of too many connections in the server.

can you guide...

Normally a dictionary file/table is used or a filter. most websites or forums utilise this form of strategy. similiar to how sql injection is basically dealt with. all input is...

WilliamBendall (10/16/2009)

---

Hi All,

I have a job scheduled to start at 5:00 PM everyday. Yesterday this job didn't start. I looked in the Job Activity Monitor view and found that the...

swear i answered this one about 10 minutes ago.

it is not an error, just an informational, just telling you that it called a extended stored procedure to read some values...

I take it that all the sql services are running, did you disable any thing else?, is there anything mentioned in the windows event logs?

lyeslink (10/16/2009)

---

Hi helpers,

I have a little problem with my security in my server SQl 2008, when a new user is created in the server, it has only the administrator rights...

It is not an error, the extended stored procedure is used to read values from the registry. I doubt that it is related to your problems.

You need to give more information if you want help, is it always going to be the 6th record or can it be any record and why is it that...

When you shrink it using SSMS 20005 do you shrink the database or do you shrink files.

if you select to shrink by files, make sure that the file type is...

did you actually shrink it using the reorganise option?

If you are concerned about the physical file size of the msdb database, last resort is to shrink it and then after that rebuild the indexes.

Can you give us more information like.

How big is the mdf file

how big is the ldf file

if you run dbcc loginfo on that database what do you get

what is your...

Siddu-916480 (10/15/2009)

---

HI,

I have a problem on my SQL server 2000.

We had a migration from old one to new one. As a part of it, detached all the dbs and moved...

Was that the answer, or did you have a caffeine free moment.

you are doubling the quotes

when you have got

replace it with

do that for all of the lines that error and you will be fine

you can...