Viewing 15 posts - 436 through 450 (of 1,583 total)
Check your Flat File Connection Manager, make sure you've specified the appropriate data types and lengths for the fields you are mapping into Excel.
If you've not done it this way...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 26, 2014 at 8:11 am
If you restore master, you will need to fix the logins for any orhpaned users., Not typically an issue however, if one of the orphaned users was the owner...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 26, 2014 at 7:59 am
For the same reason as what I mentioned above, it's a security risk. Linked servers allow security through a single account only: whether it be a sql account or...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 26, 2014 at 7:35 am
Awesome! Please mark the post as helpful so others will know to use the same 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 3:27 pm
Windows AD groups are not supported for linked Servers. This is by design and per MS, will not likely be changed going forward (based upon articles I've read in...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 1:55 pm
Running in the query designer is not the same as running it through the service (web browser)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 1:38 pm
You may want to read through this article - http://www.mssqltips.com/sqlservertip/2571/restoring-sql-server-system-databases-msdb-and-model/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 11:51 am
In the SSIS package, use the Data Conversion control in "Data Flow Transformations" to convert it on the fly, the output into your table will then be a float
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 9:56 am
Gotcha. I missed the obvious 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 9:54 am
SELECT @@VERSIO N, if the base SQL install is 64-bit then you installed SSIS as 64-bit
Ex: Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 9:07 am
Grant Fritchey (2/25/2014)
If you can't for some reason, then optimize for ad hoc, absolutely, and, possibly, forced...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 8:41 am
Please post the view DDL
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 8:39 am
Creating a procedure versus TSQL execution isn't going to buy you any performance gain as the execution plan for it will be the same. But I am curious, have you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 7:49 am
This is perhaps a silly question: When you run the "select top(1) * from linkedservername.dbname.dbo.Viewname" on the physical server itself, does it return a record?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 7:41 am
Sounds like an issue with the number of parameters defined in the actual RDL file on the SSRS server, versus the number of parameters the procedure actually has (i.e....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 7:22 am
Viewing 15 posts - 436 through 450 (of 1,583 total)