Viewing 15 posts - 1,636 through 1,650 (of 6,401 total)
No its not to do with UNION, its to do with how big your query is.
SP_MSFOREACHDB has a maximum length at 2000 characters or if quoted_identifies is on its 128.
Dont...
November 27, 2015 at 2:55 am
Can you please elaborate?
What is the problem?
Scripts, error messages?
November 27, 2015 at 1:44 am
Write the query to get it working on one DB first, then find and replace all ' with ''
November 27, 2015 at 1:43 am
If you don't specify the schema on creation it will create the object in the users default schema.
If the user doesn't have permissions to alter that schema it will fail.
It...
November 26, 2015 at 3:12 am
Are the columns the same from each DB?
If so you want union/union all
November 26, 2015 at 2:49 am
MSA's are supported on 2003 and 2008 domain controllers aslong as you follow additional setup steps to enable the support.
MSA's are supported on 2008 R2 or above schema domain controllers.
I...
November 26, 2015 at 2:41 am
The installation will assign the NT SERVICE group to the folder permissions.
NT SERVICE\MSSQLSERVER if using a default instance or NT SERVICE\MSSQL$INSTANCENAME if using a named instance.
When you change the accounts...
November 25, 2015 at 3:56 am
An SSIS package is an XML file, it cannot be converted to T-SQL.
What is the overall goal here?
1 Script to connect to multiple hosts, to download a specific table?
SSIS would...
November 25, 2015 at 1:34 am
Please post create view/table scripts along with sample data for the following tables / views
vw_tblBusinessFinancialInformation - and all referenced tables in the view
vw_tblCompany_BusinessFinancialInformation - and all referenced tables in the...
November 25, 2015 at 1:27 am
Best practice I always follow is each service has its own service account.
November 24, 2015 at 3:11 am
Import/Export is self explanatory, export data from A import it to B
Replication is a bit more complicated, see this link for reading on the topic http://www.sqlservercentral.com/stairway/72401/
November 24, 2015 at 2:30 am
Could also check sys.database_permissions and join back to sys.database_principles on the grantor to see which login did it. But if its a group then you will need to check...
November 24, 2015 at 1:27 am
Create a new SSRS project in visual studio and add the rdl files in as existing files, then add the project to TFS/Source Control
November 23, 2015 at 8:41 am
Guessing the problem is down to using WAITFOR DELAY '00:15' in the query to wait the 15 minutes.
Is a logic change possible to the job?
If so, my recommendation would be...
November 23, 2015 at 8:40 am
Viewing 15 posts - 1,636 through 1,650 (of 6,401 total)