Viewing 15 posts - 7,771 through 7,785 (of 14,953 total)
S Hodkinson (11/13/2009)
Are we human or are we dancer?
We are Devo
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 13, 2009 at 6:45 am
Alvin Ramard (11/12/2009)
Jack Corbett (11/12/2009)
Alvin Ramard (11/12/2009)
Lynn Pettis (11/12/2009)
Alvin Ramard (11/12/2009)
AVG is not interchangeable with SUM. Was that written on the day the coffee pot ran dry?
AVG*COUNT might...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 1:54 pm
Kit G (11/12/2009)
Bob Hovious 24601 (11/12/2009)
I've been trying to keep my mind out of the gutter, thank you very much.To some, or for some, the gutter is an improvement.
Guilty!
(I have...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 1:08 pm
You can't use trigger-based audits for text, image or other blob data types in SQL 2000.
What you'll have to do is do the auditing from the update commands, whether those...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 7:59 am
Yes, you can do that. You'll have problems with it if any of the parameters are for output values, but it does work for input parameters.
Because of the issues...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 7:56 am
Use a command-line control to zip it. WinZip has a command-line interface, and I'm sure other compression programs do too. Set up a batch file or issue the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 7:39 am
You can't declare a variable with the same name as a parameter.
I just tested this:
create proc ParamTest
(@Param1 int)
as
declare @Param1 int;
select @Param1 = 5;
select @Param1;
Got this:
Msg 134, Level 15, State 1,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 7:37 am
Now that's funny!
I'm having visions of the ability to talk about SQL being the primary requisite for the job.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 7:02 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 6:59 am
Not that it actually matters, but SSCertifiable is a title based on number of posts and points. The username is right above that ("GSquared"). Just like with your...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 12, 2009 at 6:58 am
How does the variable @dbname get assigned a value? Is it an input parameter?
If so, I'd do something like add this before executing the command:
if exists (select * from...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 11, 2009 at 1:41 pm
Change this:
SET @sql = 'SELECT TOP(1) login_date FROM ' + @dbname + '.dbo.User_Session ORDER BY login_date'
INSERT INTO DBA..unused_Db_Log
VALUES (@dbname, @sql)
To:
SET @sql = 'SELECT TOP(1) ''' + @dbname + ''', login_date...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 11, 2009 at 1:39 pm
Are you building the connection dynamically inside the OpenRowset command? Or are you dynamically building an OpenRowset command? I really can't tell what you're doing from the little...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 11, 2009 at 1:35 pm
The ":CONNECT" command is for SQLCMD.exe. If you use it in Management Studio, there's an option for "Use SQLCMD mode". What it does is connect to a server,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 11, 2009 at 1:33 pm
mjackson-1128654 (11/11/2009)
No reason to store it twice. It was included in the index only because it seemed faster.
What I meant was, why not make those columns the clustered index,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 11, 2009 at 1:17 pm
Viewing 15 posts - 7,771 through 7,785 (of 14,953 total)