Viewing 15 posts - 2,161 through 2,175 (of 7,429 total)
This is the better method but I think you added a bit much
CAST(DATEPART(yyyy, myDateCol) AS VarChar(4))
+ '-'
+ RIGHT('0' + CAST(DATEPART( ww, myDateCol) AS VarChar(2)),2)
March 23, 2004 at 3:33 pm
In this case you state is was create via Terminal Services to the box. What most likely is occurring is the SQL Connection is defined with something that doesn't work...
March 23, 2004 at 3:22 pm
Acutally no if Job is enabled and schedule is not it will not automatically run, also same vice versa. However even if both are disabled then it has to be...
March 23, 2004 at 3:16 pm
It is dynamic of course and can vary. You might first try making sure you reindex tables and update states and useage to ensure they are optimized and clean for...
March 23, 2004 at 3:12 pm
The easiest way is to open EM, drill down to your table, right click and choose "Design Table", then on any whitespace area and right click, choose Index/Keys and there...
March 23, 2004 at 3:08 pm
Create a local temp table available only to the user on the current connection. See temp tables in BOL.
March 23, 2004 at 11:06 am
That's what this is all about. Hope all works well for you and feel free to post here often to help others or ask when in need.
March 23, 2004 at 10:29 am
Right click on the server and review the Server Regitration Properties to make sure it is doing as expected.
March 23, 2004 at 10:14 am
Sorry should have read "isn't neccessary" in my statement.
March 23, 2004 at 7:44 am
SOrry no I haven't seen anything like this. Where would the user be typing these and why don't you if in an app write a list of acceptable functions and...
March 23, 2004 at 7:39 am
Unless you are trying to set all but the first character of the string to lower or each words first character remain upper then LOWER should handle all. If Want...
March 23, 2004 at 7:37 am
Lot's of good books out there. Personally thou I learn better from testing various ways and running into issues myself. I always found the Exam Cram books good in overall...
March 23, 2004 at 5:18 am
Right click on any whitespace or goto Package and pcik Package Properties. On the Advanced tab there are Transactions and COmmit when package completes options for the package as a...
March 23, 2004 at 5:15 am
Are you using 2000 or 7?
If 7 there is an issue with the Virtual Logs not breaking down that was never fixed. However the script here
http://www.sqlservercentral.com/scripts/contributions/26.asp
can set the condition...
March 23, 2004 at 5:06 am
How big is this database and what do you have to work with as far as available media at their location (cdr, tape, diskette, etc.) that you can fully support...
March 23, 2004 at 4:51 am
Viewing 15 posts - 2,161 through 2,175 (of 7,429 total)