You should always use a universally recognised date format so that your query works in whatever environment you happen to run it.  And don't use string manipulations - they're slower...

Since you posted in a SQL 2012 forum, I assume this doesn't apply to you, but if you have SQL Server 2016 or later, you can use the sys.time_zone_info view.

I think Perry's right - it's to do with ownership chaining.  What results do you get from these two queries?

SELECT
name
,USER_NAME(principal_id) AS SchemaOwner
FROM sys.schemas

Vijay

Does this help?

John

Given that a query returns a result set, and you're looking for two result sets per server, this isn't really possible. Certainly it isn't easy - you're trying to...

That's going to depend on what your private database...

I suspect that anyone attempting to answer your "question" would type "SSIS move files" and "SSIS error handling" into their favourite search engine and see what comes back. However,...

OK, good luck. If your server isn't running any other applications or components such as Reporting Services, I'd consider increasing max server memory to 5 or 6 GB. ...

If you make the change in SQL Server Configuration Manager, all the permissions will be assigned automagically.

John

If your database is 500MB, then the ideal memory grant should be about 582776856 bytes, not KB. I don't know what's going on there. How much memory do...

Start here: RESOURCE_SEMAPHORE[/url].

John

Do you have a third-party monitoring product such as Solarwinds or SQLMonitor? If so, you should be able to get the information from there? If you don't, do...