Viewing 15 posts - 61 through 75 (of 348 total)
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...
January 23, 2008 at 2:27 pm
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...
January 23, 2008 at 6:57 am
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...
January 22, 2008 at 1:30 pm
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...
January 22, 2008 at 1:27 pm
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...
January 22, 2008 at 12:54 pm
Hello Nita,
You will see these screens when installing SQL Server 2005 (see the attached document)
Hope this helps
Thanks
January 17, 2008 at 2:12 pm
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...
January 17, 2008 at 10:30 am
Hello Steve,
I appreciate for the quick reply. I'm looking at the header "Top Members (last 30 days)"
Thanks
January 17, 2008 at 10:19 am
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...
January 15, 2008 at 1:00 pm
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
January 14, 2008 at 9:50 am
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...
January 11, 2008 at 9:07 am
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...
January 11, 2008 at 8:07 am
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...
January 10, 2008 at 1:57 pm
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...
January 10, 2008 at 8:47 am
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...
January 10, 2008 at 8:36 am
Viewing 15 posts - 61 through 75 (of 348 total)