Please can you tell me is there some kind of limitation of concurrent client
connections in SQL 2005 Standard?
If there is, is it different for X86 and x64 versions? I mean some kind of
hardcoded limitation, not the one based on the fact that system with more

We have Windows 2008 Server and when we try to install SQL Server 2000
on it we are geting:
[Main Instruction]
This program has known compatibility issues

I have  71 million row table in SQL server 2005.CurrentlIy the database has
two datafiles(primary and secondary) and the table was created to use primary
datafile .I would like to partition this table based on date range and wrote
the code for partition data and partition schema ...

I need to create one Job that calls two jobs , and the condition is once
first Job successfully finish then only second Job should be called and i am
using SQL 2K with SP4
Any help is appreciated to determine how to do that.

This was already posted in microsoft.public.sqlserver.programming, but no
answers since yesterday.
I have the task of evaluating the effort to convert a couple of web pages of
a large application to accept multiple languages. The web pages are data

I have a new server that I will be migrating 60+ separate databases to
in the near future.  The drive subsystem is on 2 separate raid
controllers with 8 146GB drives each at raid 10.  They are then broken
down into 6 logical disks, C: through H:

I have a string of SQL commands that I'd like to put into a sp to
clean up code around my VB application. It's about 200 lines long, so
you can imagine...
Most of the SQL is quite simple, consisting of something like...

Hello --
My laptop drive is partitioned into c: and e:.  I want to install on
e:.
During Install, in Feature Selection, when I click the icon for Client

I am running SQL Server 2005 SP2 Standard Edition on Windows 2003 Server
Standard Edition (4 gb RAM, No AWE Enabled, default Max/Min Memory
settings). From PerfMon traces the overall server memory appears to be just
fine all the time.  The SQL Server appears to run out of ...

I've migrated a couple of DTS packages from SQL 2000 to SQL 2005. I can see
them when I connect to Integration Services. How do you go about editing
them in SQL Studio Business Intelligence Development Studio? I don't seem to
be able to obviously see how to open a package from ...

Hey all,
I have a site where I want the jobs to output some more detailed log
inforamation to a table/log file.
From what I've read on google, you can edit the job step > advanced >

Hi! all,
One of my sql sever 2000 ent with sp4 running on Windows 2000 Advanced
Server with sp4 is worked good, but when I start Enterprise Manager and
found can't log in the sql server, then I disconnection it but can't

Has anyone force a problem with triggers that have a ROLLBACK TRANSACTION
statement.
I have some triggers that rollback the transaction if there a user fatal
error like deletion of table rows.

I learned today for the first time about how sa, in SQL 2005, can get locked
out.  And, I found the remedy on Google.
Curious....someone told me that a network issue with Named Pipes causes
this.  Any other causes?

I need to set triggers off when  running a update command.
How ?
Thanks.
Obrigado.