I don't think it is a vulnerability because a user will have only select access to the the objects in subject.

Moreover public is default server role every login is...

chulheekim (5/4/2011)

---

I see the message below everywhere in the sql error log file. They appeared only on last Monday. What is this about?

Configuration option 'allow updates' changed from 0 to...

To add more on this TCP/IP is a widely used protocol for Internet and is often faster then Named Pipes.Named pipe could work only in LAN (Local N/W) and often...

navneetpatel (5/4/2011)

---

You can try following scripts to shrink your database which I am using. However I only work with database having one ldf and one log file in MSSQL 2008.

Replace...

SQL_Helper (5/4/2011)

---

Thanks for the replay.

I just want to know that If I run in our other SQL servers, what will be the counter values required my attention.

I mean counter value...

hello Ninja,

I always respect your words but the Error msg we recieve for...

ali.siddiqui (5/3/2011)

---

Hi;

Thanks for the query to check "BufferCacheHitRatio" & "PageLifeExpectancyInSeconds". below is the result of my one SQL 2005 server, can u please advice action to enhance server performance as...

I agree with sean. why don't you look for triggers to do the same for you.

I know trigger might delay your execution a bit because actually there will be at...

boris.kovalcik (5/2/2011)

---

Hi all,

I have problem with database size. I have one database about 330GB(4 datafiles + 2 logfiles). I archived a lot of old records to archive database and now...

Keeping in mind that the search values will use wildcard . i personally don't think we would be able to use in operator with like operator while searching for values...

Syed Jahanzaib Bin hassan (5/2/2011)

---

Backup...

Syed Jahanzaib Bin hassan (4/29/2011)

---

Yes,because he doesnt mention how many files and he mentioned files are 5GB restricted growth its mean each file have restriction of 5GB ,database size is...

Try this..

Where A= 'Value' And X in ('A','B','C')

Regards..

Yes, it is documented that sql server Express Edition does not support Sql Agent.

Also...

i was trying to restore the database which usually took 40 minitues maximum and minimum 30 minitues ,but today when i try to restore the database it took 90 minitues...