all groups > sqlserver server > august 2006 > threads for saturday august 12
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
deleting rows from one table when they exist in another
Posted by bob at 8/12/2006 4:50:55 PM
A project I'm working on has a daily update of a table and then reapplies
each day a table of updates called EditHistory.
What's the best way to do this while avoiding duplicate rows.
I want to copy all rows from the table that's been updated, then remove any
records that just came in that a... more >>
Functionality of SQL Server Errorlog
Posted by Joe K. at 8/12/2006 10:01:01 AM
What is the functionality of SQL Server 2000 Enterprise Manager Errorlog?
Thanks,... more >>
Applying SP4 on an active/passive 2 way cluster
Posted by Shiva at 8/12/2006 8:31:19 AM
I have a 2 way cluster and I want to apply SP4 on it.
Basically, I have 2 servers. Server A runs a default instance and
another instance. While the default services is disabled and the other
instance is running, Server B runs the default instance and has the other
instance disab... more >>
Protecting Data Models inside SQL Server
Posted by Peter Nolan at 8/12/2006 8:14:47 AM
Hi All,
I was talking with a colleague the other day and he made an interestinc
comment.....
He said he thought there was some way to protect the data model in an
SQL Server database from the prying eyes of a client whom the
application has been sold to.
The comment came up out of a conver... more >>
SQL 2005 change collaction
Posted by Langer at 8/12/2006 5:06:32 AM
Is it possible to change the collaction on a database during
backup/restore when we move a database from test to production. the
test environment has wrong collaction and we like to have
Finnish_Swedish_CI_AS in the production. The backup/restore is a step
in a redeployment of a MCRM system.... more >>
database disappeared from SQL 2005
Posted by JohnZing at 8/12/2006 3:33:28 AM
Hi
One of my database disappeared from SQL 2005.
Maybe my mistake (i dont remember) or some SQL problem... or..
something else.
Is there a way (logs, etc..) to see when database was deleted?
Thank You
... more >>
Please guide me to change password of win. user account use for sql server services in SQL Server.
Posted by csajid NO[at]SPAM gmail.com at 8/12/2006 1:02:31 AM
Hi,
I have Active / Passive cluster with following configuration.
O.S. - windows 2003 Enterprise Edition SP1.
H/W - 4 Processor (Xeon) + 3 GB RAM.
SQL - SQL Server 2000 ED + SP3
the password of windows account use for running SQL Server services has
changed. But as server is not rebooted... more >>
SQL Server Help Needed
Posted by gold.study NO[at]SPAM gmail.com at 8/12/2006 12:06:03 AM
Hi everybody.
I have 2 tables named daily, executive
Structure of Executive :
exe_code - nvarchar(20)
exe_name - nvarchar(100)
Structures of Daily:
fileno - int identity(1,1)
name - nvarchar(20)
resiexecode - nvarchar(20)
offexecode - nvarchar(20)
Records in Executive :
exe01 ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
