Is there a script that I can run to stop a particular SQL server service on
Win2003 server? I'm looking for a similar script to restart that service as
well. Thanks.
...
more >>
I can't seem to get the fn_get_sql function to work. Here's the script
I'm using:
declare @spid int
DECLARE @Handle binary(20)
declare active_spids cursor for select spid, sql_handle from
master..sysprocesses where status not in ('background', 'sleeping')
--and spid <> @@spid
open active_sp...
more >>
Hello all. We are just getting started with replication and I'm
wondering if there is a way to not have deletes replicated. I know I
could manually remove the delete trigger from every table but I'm
intrested in have this a bit more automatic (like when its creating the
subscription).
T...
more >>
Hi
I was in the situation of cloning a SQL server database last night.
Today, a dependent application was behaving a little erratically though
most things were fine after sorting out some ntfs permissions. I've
recovered this database from backup exec before from a hot-backup, this
is the fir...
more >>