You cannot via T-SQL, you would need to write a...

Not saying a thing 😛

Hard question Paul, I am going to go for the not online bit, If i win can I...

luckysql.kinda (9/14/2009)

---

I work as a database administrator and need to install a new SQL Server 2005 instance on a newly installed Windows Server 20003 server named LuckySql. This new instance...

Seth Lynch (9/14/2009)

---

So...

I created a role in master called accessusers and gave that execute on the proc and then gave the user that role in master.

It still feels slightly dissatisfying...

prajeevan (9/14/2009)

---

I'm trying to install sqlserver SP3 and for some reason I'm getting an error on the authentication pop message

The warning error is: "Your account information could...

rinu philip (9/14/2009)

---

thanks, i will check with the suggestions specified,however, can you tell me if I run a trace can I find out how this is happening, also what options...

viduvs (9/10/2009)

---

Hi,

I am using SQL Server 2005 from last 1 year. But this is the topic I have never understood in SQL Server.

Can anybody please give me a...

You cannot...

the...

rinu philip (9/14/2009)

---

On our test server – the SQL 2005 default instance, somehow every now and then the permission using login 'TestLogin' is getting changed for two databases.

This user should...

unikhath (5/12/2009)

---

Hi,

I'm using Script component in SSIS 2008. This is the error I received when I'm done writing the script.

Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException: Cannot create user component class. Make sure there is...

As far as I know, there isnt a BPA for 2008, it is replaced with PBM (policy based managment), which used to be called DMF (declaritive management framework)

http://blogs.technet.com/andrew/archive/2008/03/30/sql-server-2008-best-practice.aspx

use [mydatabase]

go

exec master..sp_refreshsqlmodule 'object name in here'

More probably the same guy...