I need to find the disk space estimation to create a new database with all the objects of the current databases ( without the data copied) ..for e.g. I am...

Yes, just the tables , stored procs, views, indexes stc.

Thanks

@SQLFRNDZ (2/6/2013)

---

Guras (2/6/2013)

---

We are migrating to a new domain and I have few questions -

1. I need to change the SQL server start up service account from domain1\SVC_SQL to domain2\SVC_SQL...

Can I take care of this with CASE clause in the WHERE query?

p.finclass = CASE WHEN @FINCLASS <> 0 THEN @FINCLASSCATEGORY

...

I was thinking of writing two sub proc based on the finclass value. There will be a wrapper sp that takes the finclass values and based on that I will...

This is how I restarted the agent job. I went to the local publication , found the one for the table that had problem. Right click on it , Click...

It is a transactional replication. It is strange that I cannot find that job in my SQL Agent job list.

Unfortunately we are in the prod.

No error, everything is running fine just found out that some records are missing.

I re ran the agent but still the rows are mising in the subscriber.

I could but there are certain zones in US that does not adjust the tiem for daylight savings.

I am trying to store the EST as CST , PST as CST.

The time value coming from the web application are in their local time zone but ned to...

Works great! Thanks a bunch.

This is what I have done so far

Table1

tbl1ID, client code days startcode endcode

1,clientA, 60,200, 300

2, clientB, 35, 200, 400

3, clientC, 22,100,200

Table2

tbl2Id,tbl1Id,excludecode

1,1,250

2,1,280

3,2,250

4,3,115

5,3,120

Now how do I...

Kenneth.Fisher (8/17/2012)

---

Guras (8/17/2012)

---

One of our databases is 12 GB and currently about 800 MB free space left. The database gows about 300MB in a month. I have a...