Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Create script for deploying database roles and rights

›
The script below returns the create statements for all roles in a database. It also creates the statements that add the role members to the ...

Reporting Services in SQL Server 2016

›
Installing SQL Server 2016 CTP2 (Community Technology Preview) to test Reporting Services (SSRS) is a bit of a deception: the installer does...

Analyzing string or binary data would be truncated error

›
Based on the ideas in this post, I've made an improved and dynamic version to help in determining the violating records when inserting i...

SQL Server contained database feature

›
SQL Server 2012 has a "contained database" feature. In the normal case the logins of the (SQL Server) server are coupled to the ...

PowerPivot cannot load from procedure with info messages

›
Data can be loaded into PowerPivot from a SQL Server stored procedure, but the procedure cannot contain: PRINT statements, like print ...

LISTAGG / implode solution for SQL Server

›
Group multiple records into one and concatenate the values of the string/text values of a field: ALTER view [dbo].[vcomments] as with x a...

Query Active Directory from SQL Server

›
Get active directory server and LDAP servers in a domain nltest /dclist:sub.dom.com results amongst others in: \\dcserver1.sub.dom.com -...

Create schema with separate autorization

›
Perform the following steps in SQL Server to create a schema called "bi" and give create view rights to user "domain\testuser...

Pass table-valued parameter from VB.Net

›
1) Create table type itemtabletype for a table with one, unique clustered column called "item": create type itemtabletype as t...

IsNumeric() stinks

›
Read the thoroughly insightful and funny post by Mike Teevee as a reaction to the technet documentation with regards to the useless ISNUMERI...

Silverlight not working because of font issue

›
If Silverlight is installed correctly, but still not working, check for Windows Fonts with an ampersand in the name and remove them: http:...

Analysis Services fails with "attribute key cannot be found" on Unicode field

›
ERROR The attribute key cannot be found when processing: Table: 'dbo_viu_isb', Column: 'city', Value: '　'. The attr...

Openrowset fails with "network access was interruped"

›
A SQL Server openrowset query using ODBC to retrieve data from an Excel spreadsheet fails with the error: "Your network access was in...

Packing intervals

›
Solution to the "packing intervals" problem by Itzik Ben-Gan: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals....

Execute query under cursor

›
There is no way in SQL Server Management Studio (SSMS) to execute the query under the cursor. There is the option to execute the entire scri...

Count of weekend days in date range

›
Use the formula in "calc_name" or "calc_df" to calculate the number of inclusive weekend dates in a date range. Inclusiv...

Flash 11.4 in SRWare IronPortable v22

›
To get Flash support in the portable version of Iron v22: Start IronPortable and type "about:plugins" in the URL bar Scroll to ...

MS Access DSN-less connection

›
It is possible to create a DSN less linked table and/or pass-through query from Microsoft Access to SQL Server Express without deleting th...

Oracle OLE DB source in SSIS

›
An OLE DB source to Oracle can be added to a SSIS package. Example data Server : locksnlatches.mydomain.com Oracle instance/SID : dwh ...

Reference SQL Server table with spaces from Oracle

›
It is possible to select data from a SQL Server table that contains spaces by using a database link from Oracle. The syntax is as follows:...