The link is http://gallery.technet.microsoft.com/Calculate-Leave-working-501af27a

[url=http:// http://gallery.technet.microsoft.com/Calculate-Leave-working-501af27a%5DScript%5B/url%5D

I knw its very old thread but leaving this query link for someone who needs it still now

Calculate Leave working days in a table column as a default value--updated

If...

Hi All,

In case you want to join SQL User Group for DElhi\NCR, Mumbai, Bangalore visit SQLServerGeeks.com, we've started this group 2 yrs back and did 10-11 events.

You can contact me...

Obviously this can be used in replication scenarios. Can't really comment on Performance part, as it will depend on many things like: cpu\ mem usage, workload while checking comparison, no....

Hi,

Few Months back i was also on the same road to find a wayout because our area of scope expanded to 3 new data centers, i found few options :

1....

In-addition to above, i think this needs a correction:

Article says: I stopped the SQL Server Agent from the configuration manager.

Actually, the status of SQL Server Agent should be stopped...

Great Article Rudy.

anyways people can also use XP_ReadErrorLog 0,1,'string_you_want_To_search'

like xp_readerrorlog 0,1,'error'

provided you are using SQL Server 2005+ versions

for earlier version this would be a good option.

Ninja's_RGR'us (3/5/2010)

---

Sarab. (3/5/2010)

---

Yes you are right, this approach will surely help you

for fk keys

i think the below mentioned query may help in case of fk relationship

Exec sp_MSforeachtable 'alter table...

Yes you are right, this approach will surely help you

for fk keys

i think the below mentioned query may help in case of fk relationship

Exec sp_MSforeachtable 'alter table ? nocheck...

Angela S. (3/4/2010)

---

I Needed a training database. So I copied our main database and renamed it so it won't get confusing. But now it has all the data...

check the query, default values for the destination table.

remove the StoppedDate column from the query and make sure that the column is nullable otherwise you've to specify a default value for the same.

after this run your query after...

use select schema_name()

this script will show your default schema for the login used in the respective DB selected.

as far as i know, you need to check the cluster configurations

your HDD should be added into the resource group and all the nodes should have ownership for the...

i would suggest you for single instance failover cluster rather than multi instance cluster.

for more details you can refer these

SQL Server 2005 Failover Clustering White Paper

How to: Create...