Viewing 15 posts - 526 through 540 (of 541 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 541 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy