connecting sql server 2008 from sqlserver 2005

Posted by raj on Stack Overflow See other posts from Stack Overflow or by raj
Published on 2010-04-14T06:58:41Z Indexed on 2010/04/14 7:03 UTC
Read the original article Hit count: 274

Filed under:

sqlserver2005

I am not able to connecting to the sqlserver 2008 from my sqlserver 2005....Is it really not possible to connect or there is some way..

please suggest me..if there is some thing.. Thanks.

Related posts about sqlserver2005

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

as seen on Server Fault - Search for 'Server Fault'
I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available when recovery moved into phase 3. However, it seems (based on message in SqlAgent log), that SqlAgent… >>> More
"select * from table" vs "select colA,colB,etc from table" interesting behaviour in SqlServer2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Apology for a lengthy post but I needed to post some code to illustrate the problem. Inspired by the question What is the reason not to use select * ? posted a few minutes ago, I decided to point out some observations of the select * behaviour that I noticed some time ago. So let's the code speak… >>> More
deleting records from multiple tables at a time with a single query in sqlserver2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I wanna delete records from child tables as well as parent table with in a single query. please find the query given below. here response header is the primary table and responseid is the primary key. DELETE FROM responseheader FROM responseheader INNER JOIN responsepromotion ON responseheader… >>> More
My log file is so big, after truncate it 2 days, it still big like before

as seen on Server Fault - Search for 'Server Fault'
I'm using sql server 2005 and the log is too big 23 gbs (if you compare with the data file only 8GB). I've already run the truncate, after that the log file is 24mb but after 2 days, it becomes 23gbs. My database is full backup mode. I have the maintain plan is 2 hours will have diff backup and 24hours… >>> More
Facing problem in configuring Reporting Server

as seen on Server Fault - Search for 'Server Fault'
Dear All, I am unable to configure reporting server with sql server 2005 express edition. I have posted the link of a screen shot which shows the status.when ever i go to configure the reporting services it gives me the following errors(see screen shot)...also unable to start the reporting services… >>> More

Developer IT

connecting sql server 2008 from sqlserver 2005 - Developer IT

connecting sql server 2008 from sqlserver 2005

sqlserver2005

Related posts about sqlserver2005

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

"select * from table" vs "select colA,colB,etc from table" interesting behaviour in SqlServer2005

deleting records from multiple tables at a time with a single query in sqlserver2005

My log file is so big, after truncate it 2 days, it still big like before

Facing problem in configuring Reporting Server

Categories cloud