Viewing 15 posts - 36,646 through 36,660 (of 39,717 total)
Wow, not a lot of fun, but a nice creative solution.
Thanks for the update and if you don't mind, can you post exactly what you had to run to clean...
December 30, 2002 at 10:01 am
For the first item, something like this would work for multiple rows:
UPDATE COAManyflats
SET Location=i.Location,Region_code=i.Region_code,Bedroom=i.Bedroom,Area=i.Area
from inserted i
WHERE Flatsno=i.Flatsno
Steve Jones
December 30, 2002 at 10:00 am
Let's back up slightly. What are you trying to accomplish? Why would an ASP page need to retrieve the row within a trigger?
Steve Jones
December 30, 2002 at 9:11 am
There isn't anything like this in SQL Server.
Steve Jones
December 28, 2002 at 9:21 am
Crystal sucks. Haven't used it in about 18 months, but for 10 years I've hated it.
Excel is ok, if it's text report, try to send Excel sheets since I can...
December 27, 2002 at 9:54 am
How big is this? Is it sensitive data? could you send it? (Pls reply before sending).
I'm surprised you can't attach with no log file, usually works, though suspect status may...
December 27, 2002 at 9:49 am
Not through SQL replication. DTS has a login transfer task that you could use.
There is also a createdate in syslogins that you could use to build something.
Steve Jones
December 27, 2002 at 9:47 am
Server might crash if you lose the array. If you're good with that, then no issues.
Steve Jones
December 27, 2002 at 9:45 am
I think there is an event that fires on login and you might be able to get something to work.
Instead, I'd write a job that scans sysprocesses every minute and...
December 26, 2002 at 9:25 am
I'd also bcp or DTS out the entire table to a text file to be sure you have it.
Then do a backup.
Then try rebuilding the clustered index (or creating one)....
December 25, 2002 at 4:24 pm
Happy holidays and I'd vote for Andy's solution. Much simpler to do.
Steve Jones
December 25, 2002 at 4:22 pm
Might want to also run Profiler and see what's hitting tempdb so hard.
Steve Jones
December 25, 2002 at 4:20 pm
What should happen:
User contacts SQL Server, sends credentials, SQL then verifies these with the DC and once verified, checks syslogins (and sysusers) for access before responding to the client.
Steve Jones
December 24, 2002 at 11:28 am
Sorry, not a cluster guy. Try to get Brian to look at this.
Steve Jones
December 24, 2002 at 10:07 am
Don't try to reinvent this. You will forget something and screw yourself.
Use VSS or CVS or some system designed to do this. Maintian strict controls on this.
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
Steve Jones
December 24, 2002 at 10:05 am
Viewing 15 posts - 36,646 through 36,660 (of 39,717 total)