If you attempt to modify a table that's currently being replicated, you will receive the following error

- Unable to modify table.

Cannot drop the table 'dbo.ts-services' because it...

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...

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...

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...

Awesome! Please mark the post as helpful so others will know to use the same 😉

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...

Running in the query designer is not the same as running it through the service (web browser)

You may want to read through this article - http://www.mssqltips.com/sqlservertip/2571/restoring-sql-server-system-databases-msdb-and-model/

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

Gotcha. I missed the obvious 😉

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...

Grant Fritchey (2/25/2014)

---

Yep. Those are the kind that I'd replace with some kind of parameterized query.

If you can't for some reason, then optimize for ad hoc, absolutely, and, possibly, forced...

Please post the view DDL

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...

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?