there are a number of threads here on SSC on this basic issue; it has to do with running out of memory;

there's not a lot you can do other than...

this article from Microsoft is what i have saved to get the list via PowerShell: I had this saved in my snippets, and the code I saved is unchanged from...

there is a technique for using dateadd/datediff together to get the starting date/time for any given period..year,month,week, even hour.

here's an example, giving you the begin hour and that same hour...

i have this saved in my snippets;

it's from a real comprehensive thread here:

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

it's a stored procedure someone contributed to help set up a mysql linked server, along with...

Malcolm Daughtree (12/10/2010)

---

Uhhh. Because it's a SQL server NOT a firewall. What Idiot would expose a SQL server to the wilds of the internet for it to act...

vbradham (12/9/2010)

---

It amazes me that questions get asked, and yet no-one answers the questions. I would find so useful the example asked for here.

Leave the error checking aside, I...

excel automation is tough sometimes.

i'm pretty sure the issue is the first time a user runs Excel, a dialog comes up asking for your initials. I think the initials are...

AFAIK, varchars under (8000) chars are handled the same; no performance difference when they are included with the rest of the data you are selecting...unless you are SEARCHING tha...

the default Express does not include SSMS; you need the "2008 with Advanced Services"

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

install that, and you'll have the "Express" version of SSMS; it doesn't allow you to open anything...

it depends on what you mean.

access and rights to objects are tied to a login.

if you give me a login, i can use any application i want to...

you forgot how the proc works! the question mark is substituted with the dbname!

db_name() function will keep returning master or whatever db...

the OBJECT_NAME function has a second , optional parameter for the db_id for exactly this reason;

this works in 2005 and above;

sp_msforeachdb '

select

object_name(s.object_id,db_id(''?'')),

s.*, p.*

from ?.sys.sql_modules s

...

As long as you are working with real date or datetime variables, SQL has a suite of built in functions to get the pieces you are after:

/*--results

MO ...

Megistal (12/9/2010)

---

Is it possible in SSRS r2 to pass a table parameter to a stored procedure having a UDDT in it's parameter list?

can SSRS r2 calling a procedure like this?:

CREATE...

that's the database you want to connect to.

The name "Initial Catalog" implies that you can switch to other databases after the connection, and your SQL commands could use use 3...