jacquereed (7/15/2013)

---

I put down the answer 6,6,8,6 and it said I got it wrong, but when I ran it through my sql server, it put out exactly that -- What's...

This isn't only a great solution for the problem,

it also gets rid of the dynamic sql in the sproc, which is always a horrible thing you should...

Caps off, please. No need to shout. :ermm:

You would have to code 3 inserts

or

( since you are posting in the SQL2008 forum )

You could code a single insert and...

with regards to your Powershell script:

do you actually use an xlsx template to fill out with your data?

do you actually use any excel functionallity at all ?

if not: just change...

let me answer Q1 for you : Yes

ref: Version and Edition Upgrades http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.105%29.aspx

Q3 We prefer upgrading using the migration path (backup/restore).

With inplace upgrades, the instance is configured starting from...

actually ... the correct answer may not be that correct at all :hehe:

It all depends on your ANSI_PADDING setting in use.

set ansi_padding off ;

declare @Vchar varchar(12)='prasad '

...

nice and simple trick.

Thank you for sharing.

have a look at http://msdn.microsoft.com/en-us/library/ms191545%28v=sql.105%29.aspx

it loads the default trace data into a temp table and queries it so it only shows Auto Grow events in a first query en in a second query it...

If you have default traces enabled ( should be the sqlserver default unless your installation dated pre RTM ), you can find information what extended your (temp)db.

/*

* Import Default...

+1

prvmine (7/2/2013)

---

Have to agree with others

- Format width should scale to the available display width - not a fan of scrolling on and on and on . . ....

not from my own experience, but this blog seems to address the same issue, but with SQL2008.

http://mssqlwiki.com/tag/failed-allocate-pages-fail_page_allocation-1/

did you try upgrading to SP4 ( sql2005) and then upgrade to SQL2008R2 ( include an upgrade to its SP2+cu6) ?

you could experiment with your trigger using :

SELECT T.text

FROM sys.dm_exec_requests R

cross apply sys.dm_exec_sql_text( R.sql_handle ) T

WHERE R.session_id = @@spid

hard to say.

I can drive from here to Rome in my 2CV in 5 days.

I can do the same with my Porshe in 5 days if its engine isn't allowed...