Viewing 15 posts - 37,321 through 37,335 (of 39,511 total)
June 26, 2002 at 9:46 am
Why not just build the table? It wouldn't be that hard to read information_schema.columns for the table and create the new table based on this. Of course, permissions are an...
June 26, 2002 at 9:40 am
No way to do this natively. You could do some kind of funky thing that secures access to the MMC plugin, like maybe encrypting it with a password, but not...
June 26, 2002 at 9:38 am
You would need some type of third party tool or run Profiler. I do not believe that you can set an alert for this.
Of course, you should have VERY few...
June 26, 2002 at 9:35 am
Are you backing up the database? What recovery model are you set to (database/properties)?
Normally a database backup truncates the log, allowing space to be reused.
Steve Jones
June 26, 2002 at 9:24 am
It could be. The instances will be competing for the memory on the server. Can you set both servers to use the same amount of memory and see what happens?
Steve...
June 26, 2002 at 9:22 am
I agree. you should have some primary key. You can make it non-clustered (recommended).
Steve Jones
June 25, 2002 at 5:42 pm
no cursors needed.
Use an UPDATE to update data.
update realtable
set cola = b.cola
, colb = b.colb
...
from temptable b
where...
June 25, 2002 at 5:36 pm
Curious, why does it help with Vendors? I can understand separateing the security environments, and it might be useful for applications like Great Plains which have hardcoded database names.
Steve Jones
June 25, 2002 at 5:28 pm
Totally agree on the SQL Logins. What about locking the account after 3 failed attempts!!!
Feel free to submit these to sqlwish@microsoft.com. It goes to the dev team.
Steve Jones
June 25, 2002 at 3:20 pm
It sounds like a security issue. Is the server running as local system? Or a lcoal account? Is it a local administrator.
Is this truly local or a virtual drive for...
June 25, 2002 at 3:18 pm
That will do it. In 7 you have this option, in 2000, this is "simple" mode.
Steve Jones
June 25, 2002 at 3:16 pm
You are welcome and looking forward to seeing you back here. Pls tell your friends and coworkers who use SQL Server
Steve Jones
June 25, 2002 at 3:14 pm
Haven't used them mainly because I haven't had any transactions that I use that fit.
If I did a specific update and was concerned about rolling back to that point, I...
June 25, 2002 at 3:12 pm
You could union these if you did not need the sums on the same row. If you do, then I would use each of these as a sub-select. that's the...
June 25, 2002 at 3:10 pm
Viewing 15 posts - 37,321 through 37,335 (of 39,511 total)