I was in doubt, because I found it difficult to get the intention of the question (perhaps because I'm not native English speaking). Did I need to take the question...

Open the properties of the LOGIN and look at the specified default database. Does this database exists?

According to the error message you have specified a non-existing database, the database is...

Yes, shrinking is not advisable, but I can see the need in some cases...

The performance of shrinking is depending on the allocation within the file itself. It's beyond my knowledge...

The best way is to script out the logins at the source instance and execute the generated script at the target instance. You can include the original SID's and the...

Hi, this sounds like a double-hop issue. You can read about it on http://www.mssqltips.com/sqlservertip/2312/understanding-when-sql-server-kerberos-delegation-is-needed/

When you search the internet you can find a lot of information about it.

We experienced the same when installing SQL2008 with the GUI on a Windows 2008R2 cluster. We didn't find a solution and ended up installing SQL using the unattended setup.

+1 !!

And format your code is so easy! You only need to copy/past...

The file extention MPMP is not a default SQL extention, so probably it is generated by some other process. Can you see who created (is owner of) these files?

Perhaps a...

You have to write some code to loop through and execute the generated commands. Because you want this to be initiated from 'registered servers' it is a bit more complicated,...

You have several spaces in the folder structure. Do they actually exist in the folder name?

Copy the folder structure from the code and paste it in the address of an...

Because you already have some logic in the script, why not apply some extra logic to determine the query you need:

declare @leveltype varchar(100)

set @leveltype = '1,2,3'

IF @leveltype = ''

select *

from...

The code below generates the commands to change the PAGE_VERIFY option. The CASE statements in the SELECT part is used to determine the correct option depending on the compatibility level...

And read the Select two part carefully 😀

This type of error usually occurs when the default database defined for the login is not accessible by this login (either no permission or does not exist)

gbritton1 (5/12/2014)

---

HI -- what is the correct way to add a url to a post? I clicked on the link icon and entered the desired url but when I...