Viewing 15 posts - 1 through 15 (of 37 total)
I found 30 out of 33, enough to solve the second page. And the answer to the question is, "Generally no!" Thanks, great fun and educational!
February 7, 2018 at 12:44 pm
February 3, 2017 at 4:12 am
Power BI and Enterprise Gateway to on-prem
Power BI Desktop
SQL 2016 SSRS/SSAS/AG'S
Azure SQL Database
Azure SQL VM's
January 1, 2016 at 1:27 pm
Try this code...
CREATE PROCEDURE [dbo].[dba_rpt_SQL_Files_Report]
By Norm Enger - 2007 - http://thesqlguy.wordpress.com/
Reports on the file info for all dbs on a SQL instance, SQL 2000 and above
April 3, 2011 at 10:04 pm
I happen to be in a very favorable position that allows me to live and work remotely (telecommute) from my home in Tucson, AZ, to my office in Dalton, GA....
December 12, 2010 at 10:32 pm
The below stored proc will differentiate between orphan users and and not include those created with the "WITHOUT LOGIN" clause in 2005.
IF OBJECT_ID('rpt_security_detect_db_orphans') IS NOT NULL
DROP PROCEDURE [dbo].[rpt_security_detect_db_orphans]
July 19, 2008 at 2:02 pm
See my script and RS report here which will display all the information for all databases on a server in one report.
March 4, 2008 at 6:48 pm
There is no report header region per se. The header is essentially whatever you put at the top of the report, before anything else. It could be an image or...
February 3, 2008 at 9:21 pm
This technique will work nicely. See the topics in BOL for VIEW DEFINITION for more explanation.
At a database level:
GRANT VIEW DEFINITION TO myUser
Or at the SQL instance level, for...
October 12, 2007 at 1:22 pm
From BOL: EXEC sp_renamedb N'Accounting', N'Financial'
October 12, 2007 at 12:20 pm
n type fields (nchar, nvarchar, ntext) are unicode type, are twice as many bytes to store the same number of characters. So only use if you need to store international...
June 8, 2007 at 10:42 am
September 12, 2006 at 3:58 pm
According to the readme that comes with the SQL Server 2005 June CTP, you can use Visual Studio 2005 Beta 2, but you must install SQL first, then VS. I...
August 25, 2005 at 8:16 am
If you have Visual Studio, save your sql in QA as an .sql file and open it up in Visual Studio. The file will then print with syntax coloroing from...
June 9, 2005 at 8:05 am
Try this link for the master db:
April 20, 2005 at 8:51 am