Viewing 15 posts - 2,701 through 2,715 (of 7,429 total)
What is the error you are receiving and walk us thru your process. It could be the MDAC but less likely when a manual run is fine.
However if the...
July 17, 2003 at 4:49 am
See related comments in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14278&FORUM_ID=8&CAT_ID=1&Topic_Title=Getting+UNIQUEIDENTIFIER+data&Forum_Title=T%2DSQL
July 17, 2003 at 4:43 am
For most situations the best thing I have found is to wrap the insert logic into an SP with and output variable like so.
CREATE PROC ip_DoInsert
@col1 datatype,
@col2 datatype,
...,
@newid uniqueidentifier OUTPUT
AS
SET...
July 17, 2003 at 4:38 am
Also, take a look at your Transaction Log size. Even when removing an index that file grew but I have my test machine set to truncate on checkpoint so the...
July 17, 2003 at 4:33 am
Tested today. Table with 10million rows. Added the PK and took 17minutes (PIII 500, 768 RAM, 20GB IDE HD), dropping took 2. So I wonder if there is something else...
July 16, 2003 at 7:37 pm
quote:
What would one do if a database started with identity as PK and then years later became larger than expected and ran...
July 16, 2003 at 7:35 pm
Just curious but how big is this table as far as number of rows?
July 16, 2003 at 5:24 am
Just make sure that you keep a copy of your decrypted code as it is more of a pain to lose and retrieve. Yes it can be decrypted and really...
July 16, 2003 at 4:17 am
I don't believe so but I didn't get a chance to copy a 4 gb test DB today for use at home so I copuld watch everything that happens. There...
July 15, 2003 at 5:26 pm
WHat is the exact error you get? I tried a table with a varchar(15) field and had no issues using cast on the tpyes of values you stated. Also check...
July 15, 2003 at 4:39 am
That depedns on multiple factors and the speed of various hardware components of the machine. When an index is built the CPU(s), amount of RAM, HD IO subsystem and the...
July 15, 2003 at 4:32 am
Just a comment...
With an ORDER BY statement it will generally produce the same results. The only difference may be when two or more records have the same value for the...
July 15, 2003 at 4:27 am
It is really small, I can email to youwith no issue. However, you should be able to run the install and do custom setup to get them onto your machine...
July 15, 2003 at 4:22 am
But consider what you have done with the function to get the results.
Now compare this
CREATE FUNCTION dbo.udf_LastDayOfMonth(@DateIn datetime)
RETURNS int
AS
BEGIN
return DAY(DATEADD(m,DATEDIFF(m,0,@DateIn)+1,-1))
END
Or If you want date then try
CREATE FUNCTION dbo.udf_LastDateOfMonth(@DateIn...
July 14, 2003 at 7:59 am
quote:
Hi ilan,thinking about it a while and digging in some older code, what has not been taken into consideration yet, is what...
July 14, 2003 at 4:53 am
Viewing 15 posts - 2,701 through 2,715 (of 7,429 total)