http://www.mssqltips.com/tip.asp?tip=1202

you can use a variety of ways, the article above mentioned some of these.

interesting, do you have a link to back that statement up.

pankaj.baluni (10/5/2009)

---

Hello Wesley,

I'm using SQL 2005 and didn't find ' master.dbo.sysxlogins'. please suggest how to go about it.

in SQL 2000 we do see this table. Thanks in advance.

Also, please share...

What events are you using in your trace and are you filtering it, and if so by what

What does it say in the logs, and is there any messages in any of the event logs

although you can use profiler as that is a client tool

true but that is only a snapshot at that time.

OLDCHAPPY (10/2/2009)

---

we have a sql server that is set to 6.5GB min and max memory (so fixed) but the sqlservr.exe process only shows 95MB. why is this? task...

Was tempted to point that out, but i thought i would wait to see what editions are installed first 😛

hmm, I know charindex has the limit of 8k, but like you, havent seen anything else where.

espanolanthony (10/2/2009)

---

Hello, i had posted this problem earlier and received one recommendation. Actually my SQL Server 2005 database has some fragmentation and i want to remove that fragmentation. so some...

Jpotucek (10/2/2009)

---

I have a Windows Server hosting our SQL Server 2005 SQL Server Databases at SP3

I have a Default and two named instances and I need to add a third...

another way of doing it is to :

DENY ALTER ANY DATABASE to [login]

make sure the master database is selected before running

Fred Zimmerman (10/2/2009)

---

What are the advantages of 'Append to existing backup set' in the Back Up Database for SS 2005?

Why would you want to continue to append to an existing...

moderis (10/2/2009)

---

Hello again,

I'm a (still) starter as DBA,

I got a task, to make a "sand box database" for developers in some server.

they want db_owner role, its OK. But I want...