Applying Service Packs

When applying service packs to SQL Server (2000 or 2005), does the service
pack need to be applied to the client tools running on indivdual PCs/Laptops
as well? Thanks.
Hello,
May not be required to all desktops. You can install the service packs to
the desktop machines when ever there is a requirement araise.
Thanks
Hari
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.
|||Please remember that DTS, as an example, is a client tool. If you have
different version of the client on your workstation and your server you run
the risk of getting totally different DTS packages and therefore results.
In SQL2005 the maintenance plans have changed dramatically between SP1 and
SP2. You cannot administer an SP2 created plan with an SP1 client. If a plan
is created on an SP2 server then you would not be able to maintain it from
an SP1 client.
Our rule is to update the client software when the client accesses an
updated server.
Chris
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.

Applying Service Packs

When applying service packs to SQL Server (2000 or 2005), does the service
pack need to be applied to the client tools running on indivdual PCs/Laptops
as well? Thanks.Hello,
May not be required to all desktops. You can install the service packs to
the desktop machines when ever there is a requirement araise.
Thanks
Hari
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.|||Hari Prasad wrote:
> Hello,
> May not be required to all desktops. You can install the service packs to
> the desktop machines when ever there is a requirement araise.
> Thanks
> Hari
> "MACason" <MACason@.discussions.microsoft.com> wrote in message
> news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
>
If you are running SQL2000 Analysis Services and upgrade to AS SP4,
you'll have to upgrade your AS Analysis Manager and client tools to SP 4
as well. If you don't do it, you'll get some strange errors when you try
to connect with the client tools. I'm not aware of any other scenarios
where it causes problems to run a lower SP level on the client, but
there might be...;-).
--
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Please remember that DTS, as an example, is a client tool. If you have
different version of the client on your workstation and your server you run
the risk of getting totally different DTS packages and therefore results.
In SQL2005 the maintenance plans have changed dramatically between SP1 and
SP2. You cannot administer an SP2 created plan with an SP1 client. If a plan
is created on an SP2 server then you would not be able to maintain it from
an SP1 client.
Our rule is to update the client software when the client accesses an
updated server.
Chris
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.

Applying Service Packs

When applying service packs to SQL Server (2000 or 2005), does the service
pack need to be applied to the client tools running on indivdual PCs/Laptops
as well? Thanks.Hello,
May not be required to all desktops. You can install the service packs to
the desktop machines when ever there is a requirement araise.
Thanks
Hari
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.|||Hari Prasad wrote:
> Hello,
> May not be required to all desktops. You can install the service packs to
> the desktop machines when ever there is a requirement araise.
> Thanks
> Hari
> "MACason" <MACason@.discussions.microsoft.com> wrote in message
> news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
>> When applying service packs to SQL Server (2000 or 2005), does the service
>> pack need to be applied to the client tools running on indivdual
>> PCs/Laptops
>> as well? Thanks.
>
If you are running SQL2000 Analysis Services and upgrade to AS SP4,
you'll have to upgrade your AS Analysis Manager and client tools to SP 4
as well. If you don't do it, you'll get some strange errors when you try
to connect with the client tools. I'm not aware of any other scenarios
where it causes problems to run a lower SP level on the client, but
there might be...;-).
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Please remember that DTS, as an example, is a client tool. If you have
different version of the client on your workstation and your server you run
the risk of getting totally different DTS packages and therefore results.
In SQL2005 the maintenance plans have changed dramatically between SP1 and
SP2. You cannot administer an SP2 created plan with an SP1 client. If a plan
is created on an SP2 server then you would not be able to maintain it from
an SP1 client.
Our rule is to update the client software when the client accesses an
updated server.
Chris
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.

Application goes slow or not responding after few transaction

Dear all viewer ,

Thanks to everyone.

We are using -
MSSQL Server 2000 on windows 2000 advanced server.
PB 7.0 for client server front end tools.

Prior to few days our application works fine, rightnow it get slow or not responding after few (4/5) transaction. We don't know wht it is, If anyone has same experience so that is helpfull for us.

Thanks

R.MallMonitor your activity with SQL Profiler.|||Thanks for reply

How I can do it? Can you give me step by step methods?

R.Mall|||SELECT Profiler
FROM BooksOnline

or

SELECT Consultant
FROM YellowPages|||Thanks for right suggession, I will do it.

Thanks|||I wonder if he actually did that? :)

You can also find information about running Profiler from:

www.sql-server-performance.com
www.sqlteam.com
SQL Server 2000 Performance Tuning Technical Manual (Microsoft Press)

Appending Records to the Existing MS SQL EXPRESS SERVER Table.

Dear All,

I am Using MS SQL EXPRESS SERVER .I have installed all tools available to Express Edition site.

Now I have created my database on this .I have imported a table from my MS ACCESS database (Using ODBC Datasource).This table contains 10,000 records ,

Now I want to append 1 more access Table(5500 records) to the existing table having same fields.

How to do this.Can any body tell me?

Thanks and Regards

mukesh

Hi mukesh,

You can append the imported records into the existing table using SQL Server import & Export Wizard.

1.Select Your database from SQL Server Management Studio

2.Right Click on Database and go to the Task->Import Data menu Item

3. SQL Server Import & Export Wizard will be open., choose ur data source. as MicrosoftAccess, and select the MDB file

4.Press Next to Move onChoose a Destination Page, and select your Database Name from dropdown

5.Press Next to Move onSpecity Table Copy or QueryPage, and selectcopy data from one or more tables or viewradio button.

6. Press Next to Move onSelect Source Table and View , Select your Source Table , and Destination Table and then pressEdit button,Column Mappings dialog box will be open, chooseAppend rows to the destination tabelradion button option ( it will append the new records with existing records, in your case ur new 5500 records will be apended with existing 10,000 records )

7Press Next, and then Press Finish.Import Process will be started.

Thanks

Best Regards,

Muhammad AKhtar Shiekh

SQL Server Import & Export Wizard

|||

Hi mukesh,

The way you imported the first table just load the second table but with a different name i.e Table2 to the same database and then you can use the query

Lets Table_1 is having 10000

Table_2 is having 5500

----------------

Insert into Table_1

Select * from Table_2

----------------

the simplest way to do the stuff...

Satya

|||

Thanks Mr.Akhhttar

But sir in management studio I can't find "Import and Export option" there r these option,"detach","shrink","backup","restore"& generate scripts.

thanks and regards

mukesh

|||

Thanks a lot,Mr.Satya

ApexSQL Lockwood Tech ,Anybodys Using it ?

I just got their demo but having problems with running ApexSQLDiff , any feedback how it works for others?
Maybe there are some other tools worth looking at ?
Thanks for any suggestionsWhat's it do..gotta link?

What do you need to use it for?|||I use the entire suite of products and they work great. Very good tools for the price and free lifetime upgrades.

http://www.lockwoodtech.com|||I just tried the Code part and...WHERE ARE MY FUNCTIONS?|||Huh?|||We need tools to audit databases and also to be able quickly to compare databases or to copy objects from one server to another.
So far I heard about Lockwood and Red Gate , anybody has any experience with different tools ??
Thanks|||The nice thing with Lockwood is it will compare objects, compare data, and create the change scripts for both.

The only bad thing is you must have sa rights on the servers you're comparing. The tool creates a linked server connection between the master and target in order to compare them. When you disconnect the tool will remove the temp linked server connection.

Let me know what other problems you're having and I might be able to help you out. Their website also has a support forum with some good info.|||Get Red Gate's SQL Bundle that comes with SQL Compare and SQL Data Compare.

Anyone using Quest tools ?

And if so, any pros and cons ? I have heard that Spotlight can be an
overkill on OLTP applications.
Let me know..
You are asking about Third party tools and IMHO it is better to install
evaluation edition of them and find it on your own.
In my exp. Quest tools are good enough to provide required information and
analysis.
--
Satya SKJ
SQL Server MVP.
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.
"Hassan" wrote:

> And if so, any pros and cons ? I have heard that Spotlight can be an
> overkill on OLTP applications.
> Let me know..
>
>