Viewing 15 posts - 9,796 through 9,810 (of 18,926 total)
This works in 2000, shouldn't be hard to tweak for 2k5.
SELECT Name, OBJECTPROPERTY(id, 'IsDeterministic') AS isDeterministic FROM dbo.SysObjects WHERE XType = 'FN' ORDER BY OBJECTPROPERTY(id, 'IsDeterministic') DESC, Name
June 11, 2007 at 10:29 am
How about you search how to make a trigger work on a set of rows. I'm sure that this come in handy someday!!
June 7, 2007 at 9:02 am
I think that she needs help on the fact that building a single index on a very large table takes a lot of time VS a course on why to...
June 6, 2007 at 7:24 pm
I meant with more than 1 row inserted at the same time.
June 6, 2007 at 7:22 pm
So what happens when more than 1 row is inserted in the table?
June 6, 2007 at 4:15 pm
I c, I misread the question.
This will get you started in the right direction :
SELECT * FROM dbo.SysColumns C INNER JOIN dbo.SysObjects O ON C.cDefault = O.id
June 6, 2007 at 1:19 pm
You need to know what will be the default for each datatype. But the real question is why do you need to do this?
June 6, 2007 at 11:57 am
My first and only question is why do you want to do that for?
June 5, 2007 at 9:57 am
I was reffering to something like the auto-close option. Where it gets opened when needed, but I haven't been able to find a way to do something like this... anyone...
June 1, 2007 at 3:22 pm
How about closing all the databases. Come back a while later. If the db is on then it's used by someone.
June 1, 2007 at 3:14 pm
That's not what I meant. I mean network traffic where application like EM or SSIS checks to see if the server is still online. That can be one cause of your...
June 1, 2007 at 1:52 pm
Do you have a lot of noise on the netwrok traffic on 2005 compared to 2000?
June 1, 2007 at 10:26 am
Are any of the databases using autoclose or autoshrink?
June 1, 2007 at 10:06 am
The only solution I can come up with is to hardcode the default value in the insert (which defeats the purpuse of having the default on the column).
You could also...
May 24, 2007 at 12:47 pm
If you want the default to be used you have to leave the column out of the insert. I have little experience in large system designed like this so I'll...
May 24, 2007 at 12:04 pm
Viewing 15 posts - 9,796 through 9,810 (of 18,926 total)