Viewing 15 posts - 12,256 through 12,270 (of 13,461 total)
just tested it:
create database [ ]
drop database [ ]
the above works..
create database [ ]
Server: Msg 1038, Level 15, State 3, Line 1
Cannot use empty object or column names. Use a...
October 23, 2007 at 2:32 pm
did you try this:
select'[' + name + ']' from master.dbo.sysdatabases
and then trying to drop the database in quesiton, including the brackets?
October 23, 2007 at 2:25 pm
i think your stuck with simply generating the statements as a batch, and then running them:
like this:
select'exec sp_dropuser '''+ name + '''' as SQLSTMT, * from sys.sysusers where uid...
October 23, 2007 at 7:25 am
dunno if this helps; I've used this query in the past:
select db_name(dbid),object_name(x.objid),* from (
select * from syscacheobjects) x
in an article here on SSC, i read that the columns pagesused...
October 23, 2007 at 5:15 am
here you g; this works for both 2000 and 2005, you have to run this in each instance:
typical results:
ServerName ...
October 22, 2007 at 6:46 am
double check the table...it's problebly owned by a non dbo user...
so the table is referenced by select * from lesterlogin.lester, and not dbo.lester.
since sp_help doesn't like the owner name in...
October 21, 2007 at 7:56 pm
My Dev Server for testing:
Windows 2000 Advanced Server SP4
1 Gig ram ...
October 21, 2007 at 5:12 pm
here's the results of the second pass that Jeff asked for:
SQL2000/QA ...
October 21, 2007 at 9:12 am
ok here's some performance numbers from my machine, which has both SQL2000 and SQL 2005:
Jeff's inner join example took ...
October 21, 2007 at 7:55 am
I'm assuming the field is a varchar field,
you din't give an example but there's two methods to look at below;
if the values are always the same position, or the...
October 19, 2007 at 1:48 pm
this isn't what you want to here, I'm sorry.
.NET does not use codes to identify it's exceptions like VB 6.0 did. In
.NET, everything you encounter is a "type", including exceptions....
October 19, 2007 at 11:07 am
Best;
by simply clicking on your name and looking over your previous posts, it's obvious that the moment you encounter a question, you post it here first without ever attempting to...
October 19, 2007 at 10:47 am
so...
Your saying CLR's are for people who know sql, or people who don't know sql...I'm confused. 😉
October 19, 2007 at 4:54 am
the way to do that would be with a scalar function then:
Create Function dateConstant ()
returns datetime
AS
begin
return '01/01/2007'
end
select dbo.dateConstant()
October 19, 2007 at 4:48 am
i might be second guessing you, but i believe you want to change the date to a PARAMETER, and not a CONSTANT, right?
If my re-interpretation is right, then you want...
October 18, 2007 at 12:25 pm
Viewing 15 posts - 12,256 through 12,270 (of 13,461 total)