yoffes (7/14/2011)

---

A user has a role (testrole) through which permissions are granted to her. She is working in the dbo schema, but is not the owner. The role has Create...

Koen Verbeeck (7/13/2011)

---

Oh crap. I had already trouble putting all the new features of CTP1 into a hourly session.

How am I...

The list of new features is impressive...lots of my past gripes have been addressed 🙂

Huge improvements for me:

> Load files with...

Right...but what is the result of the query I posted on your instance?

This article refers to packages that will not run at all.

is250sp (7/13/2011)

---

I have a package where the first task is an Execute Process Task that runs a .BAT...

Yes. You should start using the SQL Native Client (SQLNCLI10).

What specific version of SQL Server are you using?

SELECT 'ProductVersion', SERVERPROPERTY('ProductVersion')

@suri.yalamanchili, please consider using a Dynamic Cross Tab query instead of building a query with the PIVOT operator:

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

The article above is...

bagofbirds-767347 (7/13/2011)

---

first thing i would try is a 'GO' statement after your 'use' statement.

correct sytax would be

use [dbname]

GO

exec [procname]

but i also think lowell's syntax works.

let use know when and...

Try three-part naming to reference your stored proc instead of USE. You may also have had an issue because you were not surrounding @tableName with single quotes in your proc...

MysteryJimbo (7/13/2011)

---

opc.three (7/13/2011)

---

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...

Here is the T-SQL command to change it to Mixed:

USE [master]

GO

EXEC xp_instance_regwrite

N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer',

N'LoginMode',

REG_DWORD,

...

I could see...

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...