norbertackerman (9/25/2009)

---

I am a complete newbie so please excuse me if this a simple question.

Our SQL 2005 DB was hacked last night. In many of our tables this was appended...

or convert 😀

what build version of sql server are you running?

I can only echo what has already been said, fragmentation is relative to the table size in some respects, if you have a small table, which is constantly being changed,...

As mentioned already, they are the same as regards to what data type are allowed.

ok, different ways of populating the rest.

sys.databases will return relevant information for the databases

for the maintenence plans look at

sysdbmaintplans

sysdbmaintplan_databases

sysdbmaintplan_history

sysdbmaintplan_jobs

in the msdb database

MrT-SQL (9/25/2009)

---

Hi,

I've just read the following in an article "Index seeks cannot be made on NULL values, so A IS NULL and B IS NOT NULL should also be avoided....

LeeM (9/25/2009)

---

All,

When the tempdb files filled up, the server tried to open a non-existent temp file on a K: drive which no longer exists. We had a tempdb file...

Raghavender (9/25/2009)

---

Hi All,

I have a database with one .mdf, one .ndf file and one .ldf file.

My database have approximate 200 tables.

Here my question is:

How can I find which file...

Nice article, only of use if you have...

Good suggestions so far, if you want to script multiple job in 1 go, you can multi select the jobs and right click script using object explorer details view.

andrew.bruno (9/25/2009)

---

I have a situation where the backing up 16 databases is taking around 1 hour. This doesn’t bother me so much.

What does, is the fact that during...

Adam-393315 (2/11/2007)

---

Hi Everyone,

I am getting the strangest things happen with sql server 2005 standardthat we never had when installed on our other servers with sql server express.

Basically we have over...

Very true Mascot, thanks for pointing that out 😛

yes, drop the fulltext index and recreate specifying the language as spanish for example

if you want to do it via the gui. after looking at the properties for the catalogue,...