hmm ... what would firefighters do when they have a calm week ....

Training, reviewing, optimizing,

Training:

- persnol level knowladge and practise training

- refresh known stuff

- evaluate new techniques

- prepare...

mark (6/13/2009)

---

Good morning everyone.

I am attempting to complete some basic SQL training and I continue to receive the following error when attempting to create a procedure with a variable.

"Msg 207,...

Can you give come config info ?

(both servers/instances)

- OS ?

- sqlserver @@version

- linked server ddl statements/authentication settings

I guess you execute a sproc that has been created using "execute as login"

you may be able to actually perform stuff you normaly wouldn't be able to.

create proc usp_SSC_test

with execute...

We don't use any xprocs, so I didn't have to convert them.

We only used sp_oacreate with smtp mail. These have all been switched to dbmail in sql2005.

Maybe this link is...

did your sqlserver memory consumption grow contantly during this month ?

If yes, you may be suffering a leak and may need to plan reboots on a regular basis, unless you...

any DTA advise must be interpreted and tested before you deploy it.

You may even see quit duplicate indexes advised;

TheSQLGuru (6/10/2009)

---

I believe you are mistaken if you think that MS wasn't working on SQL Server 2008 in late...

I was still searching to get things back on track ... and got to the 32-bit issue after a while.

Thanks.

kittu123 (6/11/2008)

---

Thanks for all the suggestions. Finally I find the reason for failing. It is alias issue on X64 bit connecting to 32 bit.

Initially I created on only Alias...

Hi Alif,

Did you ever got this issue solved ?

I'm having issues exporting to access.mdb with SSIS sql2005 x64 EE.

It cannot be sql2008 ...... the feedback registration date is 11/26/2006

That's normal.

SQLServer will only wait for its standard timeout value of time.

The OS will still complete the extention after sqlserver has raised its error.

marees.inspire (6/10/2009)

---

Hi All,

When i am executing the following query

select count(*) from LinkedServer.SourceDatabase.dbo.sourcetable

It is running more than 3 hours to complete...

Pls let me know why this scenario happening...

Thanks in...

We use the same attitude Grant Fritchey posted.

To support your "support teams" requirements to be able to restore any backup on any given time and database, I would provide them...