Check that the upgrade hasn't enabled Windows Firewall - it is enabled by default.

See this page for details on how to disable it or open specific ports.

windows.microsoft.com/en-gb/windows-8/windows-firewall-from-start-to-finish

Hope this helps.

Luis Cazares (12/5/2013)

---

You can't use a variable with a comma-separated values string to be evaluated with IN().

You could as well try the Delimited String Splitter[/url].

Read the article and if you...

I've been asked before how many times a particular user has accessed objects in a database.

I solved it by creating a database audit specification to capture the SCHEMA_OBJECT_ACCESS_GROUP.

Here's the code...

http://blogs.msdn.com/b/psssql/archive/2008/01/10/sql-server-2008-resource-governor-questions.aspx

According to this link, the resource governor only limits the CPU if there is contention, so if nothing else is using CPU the limits you have set will be ignored.

http://www.sqlservercentral.com/scripts/Logins/104750/[/url]

If you are comfortable with PowerShell, this will script the login with the same password and SID.

Well I know you've done it via the GUI now, but the 3rd file looks like a full text index.

You could have just specified the path in the same way...

RESTORE DATABASE blah FROM DISK = 'BACKUPPATH\DB_FULL.BAK'

WITH STATS, NORECOVERY;

RESTORE DATABASE blah FROM DISK = 'BACKUPPATH\DB_DIFF.BAK'

WITH...

WHERE

(dbo.CostCenter.Code = @code) AND

(@Zip = 'All' OR dbo.Address.Zip in (@Zip))

This will work but won't use any index on the Zip column.

The other option is to build dynamic SQL, but...

Well I was fairly convinced it would need sysadmin but apparently not:

http://us-downloads.quest.com/Repository/support.quest.com/Foglight/5.6.5/Documentation/Database/FoglightForSQLServer_Permissions.pdf

The reason I thought sysadmin was needed is because there are some useful commands that require it. For example...

Membership of the sysadmin server role gives you system administrator privileges within the SQL Server instance.

It does not give you any permission at all on the server. If you are...

With reference to the log file part of your question, does your storage array have plenty of battery backed write cache, certified for use with SQL Server? If so, the...

I've just found out that I can edit the script, so I have corrected the error and re-submitted.

OK, so the last 3 characters of line 175 have been truncated somehow.

This should be replaced with:

JOIN sys.columns c ON c.object_id = @ObjectId

Does anyone know if it is...

Hi Mark,

Thanks for pointing out the warning. That is expected and I should have mentioned it in the article. It doesn't prevent the script from working.

Regarding the truncated line 175...

Hi Andrew,

Assuming the details in the SPN are correct (eg. it is listening on port 1433, the FQDN has been specified correctly):

Have you restarted the SQL service since adding the...