Top "Sql-server-2008-r2" questions

Want to create a script to export Data and tables and views to a sql script

Want to create a script to export Data and tables and views to a sql script. I have SQL Server 2008 …

sql-server sql-server-2008-r2

SQL Server stops loading assembly

We have developed an assembly for SQL Server 2008 R2. The assembly has been working for a week. The managed stored …

.net sql-server logging sql-server-2008-r2 sqlclr

How do I add a "last updated" column in a SQL Server 2008 R2 table?

I have a table in my SQL Server 2008 R2 database, and would like to add a column called LastUpdated, that …

triggers sql-server-2008-r2

How to prevent SSIS from truncating the last field of the last data row in a flat file?

I have an SSIS package thats unzips and loads a text file. It has been working great from the debugger, …

sql-server ssis sql-server-2008-r2 flat-file

Cannot use UPDATE with OUTPUT clause when a trigger is on the table

I'm performing an UPDATE with OUTPUT query: UPDATE BatchReports SET IsProcessed = 1 OUTPUT inserted.BatchFileXml, inserted.ResponseFileXml, deleted.ProcessedDate WHERE BatchReports.…

sql sql-server sql-server-2008-r2

Error: Failed to generate a user instance of SQL Server

I'm trying to connect to an MDF. I've even gone to the lengths of re-installing sql server express entirely (it …

visual-studio sql-server-express sql-server-2008-r2 user-instance

IntelliSense is not working in SQL Server Management Studio

We use SQL Server Management Studio 2008 R2. IntelliSense works with SA account perfectly. But it is not working with Windows …

sql-server sql-server-2008-r2 ssms

SQL Server 2008 Spatial: find a point in polygon

I am using SQL Server 2008 spatial data types. I have a table with all States (as polygons) as data type …

sql-server sql-server-2008 sql-server-2008-r2 geospatial spatial

The specified schema name either does not exist or you do not have permission to use it

I am trying to create replica of my database from SQL server to another. For that I am generating script …

sql sql-server sql-server-2008-r2

How to cast datetime to datetimeoffset?

How can i convert an SQL Server datetime value to a datetimeoffset value? For example, an existing table contains datetime …

sql-server internationalization sql-server-2008-r2