Viewing 15 posts - 526 through 540 (of 540 total)
I tried OUTPUT it din't work.
I used ODBC driver for ORACLE and was able to solve the problem by rewriting the procedure as update statements to oracle and then use...
August 18, 2006 at 7:16 am
Actually all is fine with our cluster and SAN.
It was lack of indexes on some (50 million row) tables and one operation in particular that was created with a cursor instead...
August 9, 2006 at 7:45 am
Thank you very much for providing detailed steps.
August 7, 2006 at 12:41 pm
Finally an answer i was waiting for.
THANKS BRO
August 1, 2006 at 11:05 am
Yelena it does exist in C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA.
Do i just delete the folder???
July 20, 2006 at 9:22 am
SQLBill yes that's oracle syntax.
I won't post anymore oracle questions.
I'm a sqldba but have been covering oracle stuff for a few weeks until my company finds another oracledba.
I've actually figured it out.
created a...
June 27, 2006 at 1:07 pm
I figured it out.
it was these clauses missing from the procedure
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
June 22, 2006 at 12:22 pm
Thanks for the statement.
When i try to delete jobs it still says cannot delete blah blah from MSX server.
If i delete these jobs from sysjobs will that work?
June 21, 2006 at 7:31 am
There is no such option under multi-server admin.
I only see make target make master.
The master server was deleted. so maybe that's why it's not showing up.
June 21, 2006 at 7:24 am
Thank you all for responding.
Unfortunately i don't know how many rows are in the objecttypes table.
Since they grow weekly new tables are created for each row in objecttypes table colulmn.
So best...
June 14, 2006 at 9:42 am
* What OS version and SP are you running ?
Windows 2000 SP4 Xeon 4 CPU, 2GHz, 3 gigs of memory.
* What version of SQL Server are you running and SP...
June 11, 2006 at 12:44 pm
I've tried using profiler,but the numbers are not accurate because of all our .NET apps using connection pooling.
I've downloaded SQLSPY (Freeware).
With this app i can at least know which db...
June 11, 2006 at 11:47 am
thank you for responding.
June 7, 2006 at 8:57 am
Viewing 15 posts - 526 through 540 (of 540 total)