Viewing 15 posts - 7,081 through 7,095 (of 7,429 total)
Delete the job and resetup and see if it clears and make sure if this is a SQL 7 server you are not using the 2000 client to generate the...
February 26, 2002 at 4:50 pm
I have tried several packages and don't have any names with me but I am always leary of anyone who states Whatever of the year and check to make sure...
February 26, 2002 at 4:46 pm
Great to hear. If you need I can do a break down explanation, just let me know. If not then look at subqueries, joins and case for TSQL as that...
February 26, 2002 at 4:42 pm
The problem with in passing a variable in is that when it translates it will be this
IN ('0,1,2') and not the IN (0,1,2) that you need.
In this case you...
February 26, 2002 at 4:39 pm
I have tried and found no way to do order direction as of yet. You may if the code is short just double the code with an option for ASC...
February 26, 2002 at 4:34 pm
It is entirely up to you, just make sure that you have a way in in case of an emergency if you choose to disable access. Also note that you...
February 26, 2002 at 4:29 pm
Where do you see this?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
February 26, 2002 at 11:24 am
We mostly measure downtime in our area as times when due to unavailability business processes are impacted. For instance a database about inventory only needs to be availble between 8...
February 26, 2002 at 10:20 am
Don't feel bad, none of us caught that either and I had BOL open at the time.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
February 26, 2002 at 10:00 am
If you restore a database with published tables to another server you should always get "The database is not published." error as it is just letting you know that it...
February 26, 2002 at 9:54 am
Also what does you PROCEDURE code look like.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
February 26, 2002 at 8:45 am
Easiest you will be able to do is drop like you have then just create, not worrying about what it is like.
"Don't roll your eyes at me. I will tape...
February 26, 2002 at 8:43 am
Note: I only do the convert at the end in case you are submitting a value with Date and time.
SELECT DATEADD(mm,1,DATEADD(d,-DATEPART(dd,'1/5/2002'), CONVERT(VARCHAR,'1/5/2002',101)))
As far as search, not 100% sure you would...
February 26, 2002 at 8:03 am
Try copying the Procedure out and pasting into Query Analyzer and make your changes there. Then change CREATE PROCEDURE to ALTER PROCEDURE and run, then go check.
"Don't roll your eyes...
February 26, 2002 at 7:46 am
Glad you found what you needed.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
February 26, 2002 at 7:40 am
Viewing 15 posts - 7,081 through 7,095 (of 7,429 total)