Viewing 15 posts - 151 through 165 (of 295 total)
You don't need the sp_dropserver if there are no rows in sysservers.
Basically, it's one half of "renaming a server" in BOL
August 11, 2005 at 1:28 am
Thanks.
At a first glance, and I've never got the hang of reading text plans...
1. Try declaring @nEAF as the same datatype as the column
2. Try moving the DATEADD calls into the local...
August 10, 2005 at 8:01 am
When I meant hardcoded, I meant did you put:
DATEADD(hh, -2, '03/03/2003 07:00 AM')
or
'03/03/2003 05:00 AM'
That is, before or after function...?
Anyway, query plan, not query.
IN QA
Do Ctrl-L and that is...
August 10, 2005 at 7:36 am
Remi, is this not for stored procs?
Anyway, try this:
Use local vars as Remi said AND do the DATEADD functions on the local vars before the query itself so there are...
August 10, 2005 at 7:18 am
I didn't try ", Recovery" on an other wise OK statement. I just ran the given statement and got a different error. Fair call.
August 10, 2005 at 2:31 am
Look at sp_addsrvrolemember in BOL.
"securityadmin" is what you're after.
Cheers
August 10, 2005 at 2:22 am
From BOL, "How to restore to a point in time (Transact-SQL)":
August 10, 2005 at 2:16 am
Ok, where to start?
Recovery models
A database has 3 recovery models: Simple, Bulk-logged or full. These were introduced in SQL 2000 to replace/complement "truncate log on checkpint" and "select into/bulk-copy" which...
August 10, 2005 at 1:58 am
No problems.
Always nice to be able to help and practise some coding.
August 9, 2005 at 6:07 am
Float is probably out because it's not exact.
What about a composite key, say
2 decimal (38,0) fields, defined as the PK
It'd need some trigger or sp code to count up but...
August 9, 2005 at 3:58 am
Try "decimal (38, 0)"
Gives 10 ^ 38 or so.
August 9, 2005 at 3:13 am
IMHO, I think you're making it hard for yourself, but I'll try and give you some ideas.
Multiple instances (6 of them on 1 box or 2 per server, 3 server)...
August 9, 2005 at 2:31 am
You need TCP/IP for kerberos and pass through to work. Period.
Personally, and I say personally, I'd disable named pipes.
Unless you have legacy apps (such as those using BDE admin or...
July 26, 2005 at 8:56 am
If you fix it, let me know 😉
I've had this for years now.
Sorry I can't be of any real help.
July 25, 2005 at 4:22 am
Viewing 15 posts - 151 through 165 (of 295 total)