Forum Replies Created
Viewing 15 posts - 10,936 through 10,950 (of 18,923 total)
-
RE: Strange results when calling a SQL stored proc from within an Access 2000 project
Did you even try my solution. I had the exact same problem as you had and I resolved it simply by executing a single line of code when creating a...
-
RE: Performance when using UNION in a view
What's the difference in the execution plans?
-
RE: use stored procedures in a cursor
Can you explain the process in details of what you are trying to do?
-
RE: Tuning an SP
One way would be to use either dynamic sql or create a single sp for each combinaison of parameters possible. Then optimize them all separatly. I would do that ONLY...
-
RE: retrieving values from one select statement
Yes rethink this. What are you trying to do in that module?
-
RE: use stored procedures in a cursor
Why would you want to do that exactly?? Those functions should be called when deploying the application, not during!?!?
-
RE: number of connections made to a database
I have no idea if this will work for 2005 :
Select * from master.dbo.sysperfinfo where counter_name = 'User connections'
EDIT 8000
-
RE: how to find the number of connections made to a database
Please dot not cross-post, we monitor all boards. Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=325217
-
RE: Security Question->User need to Alter tables, but objets must remain current dbo
What happens if they run this : ALTER PROCEDURE dbo.SpName ....?
-
RE: How to link a SyBase server from SQL Server?
Thanx... Maybe I should have checked your post log before posting mine
. -
RE: How to link a SyBase server from SQL Server?
Can you post the link from here to there or there to here so that we don't answer his question 3-4 times?!
TIA.
-
RE: Facing problem with executing large-value query variable
Can you post the query that is erroring out?
I suspect a cast (explicit or implicit) that would truncate the data is throwing the error, and not the dynamic sql itself!
-
RE: Creating a new table with a unique field
We need to know the WHOLE ETL process to help you on this one.
Sample data and required transformation is needed also.
-
RE: Our Very Own SQL Server Data Compression
Nice article Steve. Just out of curiosity, how many e-mails do you currently send monthly?
-
RE: Structure of SP results
No directly from sql server (unless using DTS). Here's what I would do :
IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'DemoFMTONLY' AND XType = 'P')
DROP PROCEDURE dbo.DemoFMTONLY
GO
CREATE...
Viewing 15 posts - 10,936 through 10,950 (of 18,923 total)