Hello Linda,

You can't create backup schedules and maintenance jobs on the mirrored database as it will be in restoration state every time and it will be only be accessible when...

Hello Brett,

Instead of writing a stored procedure why don't you convert the same to a function and return the count of downloads. So in this way you can get the...

Hello Sam / Richc,

Have you people tried to ping the said error servers from the machine which you are trying to register / add ?

May be the server name which...

Hello Ishaan,

There might be 'n' number of connections to the same database but there might be some which are not doing anything. You can check on a development machine by...

Hi Jason,

In your scenario, I would go ahead and initiate a SQL Profiler Trace to look for the transactions that are hitting the most on one of your databases. Then...

Hello Nita,

You will see these screens when installing SQL Server 2005 (see the attached document)

Hope this helps

Thanks

Hello,

Can you test this sample at your end?

Create table a (dt text, dt1 text)

insert into a values ('this is to', 'test the concatenation')

select * from a

create table b (dt2 text)

insert...

Hello Steve,

I appreciate for the quick reply. I'm looking at the header "Top Members (last 30 days)"

Thanks

Hello,

Before going ahead with setting the identity insert to on and then inserting the record, make sure that there is no record available for the specific id. Based on your...

Hello SC,

These are some of the links I grabbed while searching just like you!!!

http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

http://msdn2.microsoft.com/en-us/sqlserver/aa336316.aspx

Hope these help you in bringing up to speed.

Thanks

Hello David,

The Upgrade Advisor will not change the compatibility level to 90 but keept it as 70. You need to change it but before changing it you need to check...

Hello Sid,

Yes it would be better if you can do it in SSIS as it has the ease to use. You can use the individual txt files and then pump...

Hello,

First you need to install the RTM version of SQL Server 2005 and select the required components as

1. Analysis Services

2. Reporting Services

3. Integration Services.

After everything is installed successfully, then you...

Hello Dom,

I think you have messed up with the steps to move the databases from one location to another location. As you are trying to move the databases including the...

Hello Prakash,

You can monitor the required components in different ways. It would be very useful if you can initiate alerts sent to you for the components to be monitored. A...