Viewing 15 posts - 2,881 through 2,895 (of 3,008 total)
You have to make sure you get your personal priorities taken care of too. If you are just living to work, what’s the point?
They say that no one lays on...
March 22, 2007 at 8:57 pm
You still didn't say which values of value_a and value_b cause the problem.
March 22, 2007 at 7:26 am
What are the data types of value_a and value_b?
What values of value_a and value_b cause the problem?
March 21, 2007 at 12:08 pm
I prefer the "ignore them and let the server admins worry about it" approach.
If people with their own instance of SQL Server come to me with a problem, I tell them they installed it,...
March 21, 2007 at 9:52 am
The server probably has Internet Explorer Enhanced Security installed.
When the job runs, it pops up a dialog box to ask if you really want to run CSCRIPT. Since it is...
March 21, 2007 at 9:19 am
You can just take the database offline before starting the restore, and that will prevent connections.
alter database MyDatabase set offline with rollback immediate
March 20, 2007 at 8:43 am
You code does not work for days before 1900-01-01. Notice in the code below that it returns a Friday that is later than @mydate.
The code I posted works for any datetime...
March 19, 2007 at 9:34 am
This returns all Mondays from 2000-01-01 through 2010-12-31
select a.Date from -- Function F_TABLE_DATE available on this link -- http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519 dbo.F_TABLE_DATE ( '20000101','20101231' ) a where a.DAY_OF_WEEK = 2 order by a.Date
March 19, 2007 at 9:10 am
You can use the Start of Week Function, F_START_OF_WEEK, on this link:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307
Or you can do it directly with this statment:
Select LastFriday = dateadd(dd,(datediff(dd,-53686,@MyDate)/7)*7,-53686)
You didn't say what you wanted if...
March 19, 2007 at 8:55 am
This question was posted on SQLTeam also, and I posted a similar answer there earlier today.
March 12, 2007 at 9:31 pm
I have never heard of this happening.
Have you considered the possibility of human error?
March 12, 2007 at 1:45 pm
I am not saying 4 GB with SQL Server Standard Edition it is a bad idea, but I just wanted to make sure he knew that it was memory that will...
March 12, 2007 at 9:02 am
So what happened when you logged onto the server with the SQL Server Agent service account and ran the package?
March 10, 2007 at 4:38 pm
Viewing 15 posts - 2,881 through 2,895 (of 3,008 total)