Hi,

Try using these functions....

HOST_ID() ,HOST_NAME() ,APP_NAME()

Good luck

Hi,

Try select * from servername..database.dbo.table

Hi,

Maybe im still a little slow after my holiday at the coast! Why whould you need to have more than 249 non-clustered indexes on one table!

Hi,

I have made a decision to add 4 more processors to one of my 32 bit partitions and create a new 64 bit partition with Datacenter 2003 as the platform....

Hi,

Try this .....

http://support.microsoft.com/default.aspx?scid=kb;EN-US;115519

Andy.

Hi

Do you know why windows-based installations have gained the reputation of working less effective, have more downtime, and so on?

Because as you say it’s so easy that just about anyone...

dillygaf

DOES IT LOOK LIKE I GIVE A F....

If it aint broke don't fix it!

We all seem to have our own Naming Standards that we have developed over time. Have a look at this article as its close to my standards but has some...

To the best of my knowledge no. Each user will connect to SQL server using there own SPID.

If it aint broke don't fix it!

I have the Yukon beta and I must say that im impressed!!!!!!

The interface looks a lot like Visual Studio and replaces EM,QA and allows MDX queries to be built in...

Brian wrote an article on MOVING diagrams

http://www.sqlservercentral.com/columnists/bknight/transferdiagram.asp

I know this is not what ur asking for , but maybe it will help you cut corners to get to what...

Hi,

I have never seen this before. Was there enough disk space for the Data files and Log files before running DBCC DBRECOVER.

If it aint broke don't fix it!

I hope that this is what you were asking for....

CREATE PROCEDURE usp_dynamic

@TableName varchar(128)

as

DECLARE @SQLstmnt nvarchar(1000)

SET @SQLstmnt = 'SELECT * FROM ' + @TableName

EXEC sp_executesql @SQLstmnt

GO

If it aint broke...

Hi,

Yes I agree. Its definitely the OS. This DTS run for a year and a half on another machine. Its been ok for 6 months on this server. Any ideas...

Greetings,

I have managed to resolve this. An EXCEPTION_ACCESS_VIOLATION error led me to believe that this is a memory problem.

It occurs when a pointer is dereferenced and the pointer points to...