Hi,

One of the recommendations of when to install instances is when you need separate security for different applications or customers. Logins belong to the instance, not to individual databases. So...

Jane,

Thanks. We will try stopping the MSDE instance when applying SP3A to the clusterd Enterprise instance today and I will post the results.

Yelena

Steve,

Good Luck to your son! I have a 12 year old and today is his play performance.

Your son will make a great database programmer. I know what I am talking...

Brian,

I am helping someone with cluster where one Enterprise edition installed as Default instance and MSDE installed on one node. The service pack 3A was installed on both but something...

Please, first make sure that what Mike said is done.

I would say it does not look as permission problem from the error message. The error mesasaage looks like that instance could not be...

What is the prefix? If it is

SomeUser.MyTable then a login SomeUser created this table.

If it is dbo.mytable than it was a database owner who created this table(see his...

Hi,

Read this

http://www.microsoft.com/sql/techinfo/tips/administration/May3.asp

and change this:

• In SQL Server 7.0, the key is:

  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \MSSQLServer\MSSQLServer\LoginMode

• In SQL Server 2000, the key is:

  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft

  MicrosoftSQLServer\<instance_name>\MSSQLServer\LoginMode

The value of LoginMode is 1 for Windows Authentication only, and 2...

Francesco,

How do you store the actual DB login and password? Do you use sort of encryption? If any passwords are stored in the DB, is it the same DB as...

Tom,

Do you mean "application role" like SQL Server Application role, which is a good solution, or "application login" which is a standard login and is generic? I would not use...

I will do it as a VBscript The type of the Task is ActiveX Script Task.

Create FileSystemObject File object and check its size. Or if you think that the first line...

There are references to Trace Flag 1807 like

http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx

• Trace flag 1807 

You cannot create a database file on a mapped or UNC network location....

Alex,

Oh, well. Your work is like working with elementary particles (electrons etc) in physics: taking the measurements affects those measurements themselves because of wave nature of both.

In this case, it does...

Alex,

You say "...So, when they find a "control" group of cases that works through the production DB..."

I work in the regulated environment. The test cases are mostly requirements-based. Anyway, QA in...

Jeff,

register your server in Enterprise Manager using any login that has sysadmin privileges, like SA or the one that you created.

Then go to Security, New Login, Windows type, select your...

I did not get it: the explanation says: "NOTE: Backing up to RAID 0 is not recommended" and it is a correct answer. Oh, well, maybe the dialectical concept of...