What does this return on your server?

SELECT @@MAX_CONNECTIONS ;

You can also use this:

EXEC sys.sp_configure

@configname = 'user...

MysteryJimbo (7/13/2011)

---

Oddly enough, this isnt true and is something Microsoft dont really reveal.

It is actually 32767 concurrent and running connections as its based on an smallint value but is generally...

I would like to try a few things out on this side. Just so we're on the same page which version of SQL Server and SSIS are we on?

Are you sure it is a process within SQL Server using high amounts of CPU? What else is running on the server?

If you're sure you're supposed to be looking at...

From http://technet.microsoft.com/en-us/library/ms179874(SQL.100).aspx

The actual number of...

XML operations can use more than a trivial amount of additional CPU over an equivalent operation done in standard T-SQL or even CLR. It will depend on many factors so...

http://technet.microsoft.com/en-us/library/ms152751.aspx

32-bit Windows right?

This happens when your server runs out of MemToLeave memory area. It's related to limitations with the Virtual Address Space in 32-bit windows and the only cure is...

I have some experience with jTDS (1.2.x) and I was left unimpressed by their Unicode support when connecting to SQL 2008 R2. Have you tried the Microsoft JDBC Driver 4.0...

Note: Asynchronous database mirroring (a.k.a. High-Performance Mode) is supported only by SQL Server 2005 Enterprise Edition Service Pack 1 (SP1) and later versions.

I agree with Koen on all points. The File Watcher Task is far easier but it will require an extra file to be deployed to all your servers before your...

This are nice standards, but where do they talk about standards for naming the database itself, or...

shubham.saxena67 (7/8/2011)

---

Hello friends,

I have created a database with name caspa_in_caspa that is associaded with a user caspa_in_caspabareilly and

when we are creating table in database caspa_in_caspa though query it is created...

+1 on the calendar table

Here is a function that can help you generate one from scratch with lots of useful columns:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

PhilipC (7/11/2011)

---

I generally try and keep it to the name of the product with a DEV/PRD/UAT/TST, etc tagged on the end of it, but just curious what others do and...