Viewing 15 posts - 91 through 105 (of 132 total)
Matt. Thanks for the idea. I think it may work. I'll try it on Monday.
May 30, 2008 at 9:10 pm
Jack. Thanks for your post.
I'm at home for the weekend now. I'll post some code on Monday.
The essence of it though is I'm testing for the exitance of...
May 30, 2008 at 9:05 pm
Thanks for all of the feedback. I realize I should have provided a bit more detail. After I posted, I learned, by reading the help files that;
- I...
May 30, 2008 at 8:58 pm
And that's even cooler yet since it gives me milliseconds as well. I like it! Thank you.
May 29, 2008 at 6:43 am
Thank you both Steve and Matt.
Steve;
While you were replying I was doing research and came across the date math solution that you mentioned at
http://www.sqlteam.com/article/working-with-time-spans-and-durations-in-sql-server
It wound up looking like this;
PRINT...
May 28, 2008 at 3:00 pm
So - if I have BULK INSERT privilages in the TempDb I'll be able to make this work?
May 16, 2008 at 7:55 am
Hmm.
Sounds like the upshot is that something that should be simple - isn't.
Here's the nut of my problem.
I have an application which can execute SQL scripts directly (I have the...
May 16, 2008 at 7:54 am
Well! That would be an important piece of information! I've been doing a lot of research on this problem and haven't come across that.
Do you have any docmenteted...
May 16, 2008 at 6:41 am
Yes I have.
I have also tried it creating a permanent table (I have dbo authority) and it works as desired. The problem has something to do with it being...
May 15, 2008 at 1:10 pm
Hi Loner. Thanks for the reply.
I've tried your ideas. Still no joy.
I think it has something to do with privileges but I'm not sure what it is yet.
I...
May 15, 2008 at 10:11 am
That would explain it.
We're in the midst of transitioning from 2000 to 2005. I'm kind of schizophrenic myself these days 😉
May 15, 2008 at 8:10 am
Hi Jason;
Thanks for the post. I had some trouble with the syntax. I don't have sys.tables or sys.indexes. I think sys.indexes should have been dbo.sysindexes
Anyway - this...
May 15, 2008 at 7:46 am
More...
I'm hoping to use something like;
SELECT [TABLENAME] from
WHERE FileGroup = [FILEGROUPNAME]
Am I dreaming in technicolor?
May 15, 2008 at 6:50 am
Viewing 15 posts - 91 through 105 (of 132 total)