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: 255
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.
© Stack Overflow or respective owner
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
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
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
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
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
