Tag: sql-server-2008-r2

Move nVarChar data from one table to another and return PK to origin table

I am looking for advice on the best SQL Server 2008 R2 approach to move a reasonably high number of nVarChar data type rows from one table to another (actually there are a number of tables). In summary the objective is: chapterOne is a table that has a nVarChar column called page_content a new table […]

Some tables id column do not auto increment despite being identity

I am troubleshooting a db (not my forte) that has some tables that are auto incrementing on the id column and some tables are not? Now all the tables are set as identity and marked to disallow null. I am using SSMS what else can I check or do to get these tables back to […]

Rebuilding SQL Server tables

Some of SQL tables have 0 rows and yet have a large about of TotalSpace reserved. These SQL tables are used to temporary hold data (which I am not sure why the vendor did not use temp tables). The only way I can free up this space is to rebuild the tables. I am thinking […]

SQL Server view for calc ParentId column

I have a table with following sampled rows: Id CompanyId value 1 X a 2 X b 3 X c 4 X d 5 Y e 6 Y f 7 z g 8 Z h 9 X i 10 X j I want to have a view with following result : Id CompanyId ParentId 1 […]

BIDS keeps crashing

I am working on SQL SERVER 2008 R2 and BIDS Visual Studio 2008 Version 9.0.30729.446 , The problem is it keeps crashing, It just restarts itself. Did some googling and found this Hotfix Visual Studio 2008 SP1 crashes when you open a BIDS project. I have download and applied the hotfix but the issue persists. […]

Database Backup Job Failed

I have a sql agent job setup for taking full backup every night. Last night the job failed with the following error message. Sql Server Error Log Message BackupIoRequest::ReportIoError: write failure on backup device ‘H:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\My_Database_backup_2014_04_28_233008_2135500.bak’. Operating system error 2(failed to retrieve text for this error. Reason: 15100). Error: 3041, Severity: 16, State: 1. SqlAgent Job […]

Can I setup linked servers linking SQL Server 2008 to SQL Server 2008 R2?

Basically this is a backwards compatibility question – our report server is SQL Server Enterprise, and all our Production Servers are going from SQL Server 2005 to SQL Server 2008 R2, so will our reports server need to be upgraded to link to the new R2 production servers? Thanks in advance!

Connect To Sql server which is in other domain from WinForms using Windows Authentication Mode

I have created WinForm App and want to connect To Sql server using Windows Authentication Mode. But Sql Server is in other domain and WinForm App is in other domain. I am not able to connect. Tell me how to do this ? Edit These two systems are in same LAN but in different groups….Do […]

SQL Server : Trace Database activity or logins on fully qualified table query

I am trying to audit our security for our SQL Servers. I am trying to run a trace on a database to get the users that logon and access the database. However if the query is ran from a different database there are no logon events generated. Example: I am trying to trace logons for […]

Microsoft SQL Server: Error HRESULT E_FAIL has been returned from a call to a COM component

What does this error “Error HRESULT E_FAIL has been returned from a call to a COM component” in SQL Server 2008r2, I create file sample. SQL from SampleDb with Task->Genaret Scrpits, the file content Data and schema, my file size is 137m, when I want to open this file, This error was generated. Please help […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.