Viewing 15 posts - 34,846 through 34,860 (of 39,903 total)
I'm not sure what you mean. Do you mean physical illustrations or txt examples? There are a few articles on the site dealing wiht this.
http://www.sqlservercentral.com/columnists/sjones/intherealworlddisaster.asp
http://www.sqlservercentral.com/columnists/awarren/disasterintherealworld2.asp
August 4, 2004 at 11:25 am
insert into TableA
select flag, memberid, ...
from #tmptable
where flag = 'A'
update tableb
set x = y
from #tmptable
where flag = 'C'
etc.
August 4, 2004 at 11:14 am
something like this will work if you can determine some "key"
select code, yr, per01
from mytable
where yr = 2003
union
select code, yr, per02
from mytable
where yr = 2003
union
select code,...
August 4, 2004 at 11:13 am
Did you either of these?
select count(*) from master.dbo.sysperfinfo
select * from master.dbo.sysperfinfo
Do they both return 0 rows? I'd guess that there is something wrong with the SQL installation in getting counters....
August 4, 2004 at 11:09 am
Block them at the router/firewall. If it's a DMZ, you can do that.
August 4, 2004 at 11:09 am
Most likely the cookie is on your machine for someone else's login. I'd try logging out and back in again.
August 4, 2004 at 11:00 am
Pls don't cross post, we check all the forums. Answered in another thread.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=129930
August 3, 2004 at 11:42 am
You can give create permission, but drop goes to teh table owner. I'd give them create under their user name, so they'd create tables as
bill.mytable
You can use sp_changeobject_owner to move...
August 3, 2004 at 11:32 am
Not that I know of. Lumigent's Log Explorer, Log PI, Apex SQL, all have tools to read the log. I built one awhile ago, but it had flaws.
Big hammer held...
August 3, 2004 at 11:10 am
It should be related to backup and recovery. Lost tape, backup failed, not checked, restore didn't work becaues of paths, server blew up, had to cobble one from desktops, ...
August 3, 2004 at 11:08 am
temporary tables, assuming this isn't a ##mytable and it a #mytable, are unique to each person. Even if you create the same name, SQL server will change the name internally...
August 3, 2004 at 10:52 am
I agree that text would be better. If you want to try and save space, you could set the text_in_row for this table to 1000 or 1500 and get all...
August 3, 2004 at 10:49 am
There might be something with terminal services. The client tools aren't necessarily designed for this work. I've had some issues with this before, but I tend to run terminal services...
August 3, 2004 at 10:05 am
Need 1433, TCP open. 1434 UDP if looking for instances.
August 2, 2004 at 5:51 pm
I haven't done this, but in my understanding, you can install in English and add the database, table, or even just the columns that you need to support a particular...
August 2, 2004 at 2:54 pm
Viewing 15 posts - 34,846 through 34,860 (of 39,903 total)