Viewing 15 posts - 316 through 330 (of 1,179 total)
Check following common IIS-related services:
Service Name
Iisadmin
Msftpsvc
Nntpsvc
Smtpsvc
W3svc
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2014 at 11:14 pm
My suggestion; do not change/update any thing on system table/database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2014 at 11:06 pm
Database which you are going to restore is in use hence your restore fail. No one should connected to the database your are restoring. If you found any connections to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2014 at 11:02 pm
Easy One! thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2014 at 10:59 pm
Yes, your error is very correct as there is no column called 'SSMA_TimeStamp' on the table 'doctors'.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2014 at 10:43 pm
What error you are getting?
sp_MSforeachtable will perform the execution on all the tables but you need to remove the column from some tables?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 5:30 am
As mention by Stuart you need to kill the connections for required database. If database is in use; you can't perfrom restore operation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 4:09 am
It is not advisable to put anything like user proc on master; instead you can create new database and store stored procedures. Also it is not a good idea to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 4:05 am
If you do have multiple databases/applications on server you can move some of the application to other server to reduce the load.
If load on the server is more the only...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 3:59 am
It purely depends on the customer requirement. We can't create more database and put more data to manage. Instead of finding howmany DB supports try to understand environment of the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 3:54 am
radek.hruby (4/4/2014)
Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx
Appreciate your help to find out this link.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 3:19 am
radek.hruby (4/4/2014)
Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx
Appreciate your help to find out this link.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 3:09 am
Yes, CDC can be used to update DW database. Refer following doc
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 3:03 am
Also if publication not set up to replicate schema; you need to remove and add from subscriber & publication. Also need to run snapshot agent to pickup the change.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 12:04 am
Still I will let SQL Server to decide instead of external WITH RECOMPILE.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2014 at 11:37 pm
Viewing 15 posts - 316 through 330 (of 1,179 total)