Viewing 15 posts - 76 through 90 (of 154 total)
Below query will return the row count of user tables in a db.
SELECT o.name AS "Table Name", i.rowcnt AS "Row Count"
FROM sysobjects o, sysindexes i
WHERE i.id = o.id AND...
December 31, 2009 at 4:33 am
Scope is limited for temptables and Temp variable.
September 28, 2009 at 6:13 am
A, B and C are the databases and you have a snap shot agent for database A. A is your publisher and D is your subscriber then we can do...
September 18, 2009 at 5:11 am
use the following in a script so that this will fix once its restored
sp_change_users_login 'report'
sp_change_users_login 'Auto_Fix', 'usr', 'pwd'
August 4, 2009 at 1:44 pm
If its a staging /testing server and no logshipping in place then put DB to simple recovery mode so that it will truncate the log automatically
๐
August 4, 2009 at 1:39 pm
By default AWE will be allocated with complete amount of Ram in MB's. If we restrict that much it will usew for sql server and remaining it will allow for...
July 7, 2009 at 10:50 am
Using @@Error will be good practice because the database objects wont rollback if there is an error in the script, That time either we neeed to check from...
July 7, 2009 at 10:37 am
Can you be more specific in server name like Publisher or Subscriber?
Check the distributor properties
Best way is to check in Replication Monitor..
July 7, 2009 at 8:16 am
No Problem in the installation. When we insert 'NULL' as a char that will be in Yellow. If its empty and its also Null that will be in another...
June 26, 2009 at 9:30 pm
Login:
Create login with password =
Which will create a login for sql server so that user can use this credentials to connect the sql server.
User:
A user is DB user which...
June 26, 2009 at 3:58 am
First thing ,
Make sure on primary key column there should not be any duplicates from the column you are mapping.
Secondary,
When you import for the child tables check that amount of...
June 26, 2009 at 3:50 am
Viewing 15 posts - 76 through 90 (of 154 total)