Viewing 15 posts - 121 through 135 (of 151 total)
You have to type in .bak or whatever you're suffixing them (the files) to get SQL Server to delete. It doesn't default to this...
February 25, 2009 at 9:43 pm
Yeah we're using it. I say "we", they are; the movement to a complete n-tier thanks to OOP programming via vb.net and c# has led to a complete removal of...
February 25, 2009 at 9:41 pm
Oh ok gotcha. Probably 100 ways to do it, here's my quick try. Use this and come up with something better. Now that I look at I almost deleted...
February 25, 2009 at 8:57 pm
Maybe this will help get you going???
CREATE TABLE Proj
(ProjId INT
,ProjDt DATETIME
)
go
CREATE TABLE ProjComments
(PCID int
,ProjID int
,Comment varchar (400)
,CommentDt datetime
)
INSERT INTO Proj VALUES (1,GETDATE()), (2, '1/1/09')
INSERT ProjComments VALUES (100,1,'COMMENT', '2/1/09'), (200,1,'COMMENT2',...
February 25, 2009 at 6:40 pm
Cant you simply create a derived table and join back to your main table (correlated subquery), the derived to include top 5 order by the date desc?
February 25, 2009 at 6:02 pm
I agree, not sure why you would ever want the same data in another column; maybe you should make it null or add a placeholder, and then do some calculation...
February 25, 2009 at 5:43 am
I've noticed that they keep removing shortcuts as well (although I haven't gone to see if they're addable...), such as CTL + B in SQL 7 and 2000 to size...
February 25, 2009 at 5:21 am
We have a situation where we have TEMPDB on the same disk as the user databases. Also, we have read the research where the consensus is to put TEMPDB...
February 24, 2009 at 7:02 pm
You may also have to look in SSMS at Query>>Query Options>> Results - Text and change "Maximum number of characters displayed in each column" to 8000. Think that's the max...
February 24, 2009 at 6:54 pm
So try a qdf.Execute and see if it gives you option. qdf won't run by itself I don't believe.
Lee
February 24, 2009 at 11:52 am
February 24, 2009 at 11:49 am
I haven't done access programming in years, but just looking at it, I don't see where you have given a command to actually execute the stored proc. Can you check...
February 24, 2009 at 11:40 am
You would need to add it to a BIDS solution in Visual Studio to edit; options for SQL Server are to save to an SSIS box (a server running integration...
February 24, 2009 at 11:36 am
February 24, 2009 at 11:27 am
Viewing 15 posts - 121 through 135 (of 151 total)