Hi All- error :SQL Server Database Health - High impact database is unhealthy "when i register this prod server..i dont see any databases and in...
Hi all, I had to repost here as this is a dts topic. sorry about this..... I have to create a automated package. Firstly i have to import 2 specific...
I am working on sql server 2000.... thanks YUKON DBA
Hi all, I have to create a automated package. Firstly i have to import 2 specific columns from a excel file to create table1 in a database. then i...
Hi All, Could anyone give me info or link for step by step procedure to import an excel file data to a sql 2005 database . any help is appreciated...
I guess this link is for sql server 7.0.....i am looking for sql server 2000 and 2005 log shipping setup. Anywayz thanks for the info. Yukon DBA
Hi All, can anybody suggest me a good link or material for step by step setup of sql server 2000 log shipping as well as sql server 2005 log...
Hi All, Need to know info about the following. I appreciate any answers or links.. How to check memory leak? How to know index percentage usage? How...
thanks a lot Satya ...the info was indeed helpful Yukon DBA
I need to know about both windows and sql user
Hi All, I need to know how to add user in secondary server in logshipping (sql server 2000 and 2005) Thanks in Advance Yukon DBA
Hi All, Can anyone give info about the following questions. Any info or links appreciated in advance. 1) How to give IIS authentication from sql...
Hi All, I have taken a backup of two databases of 40 gb and 95 gb and than tried to execute the following command to verify the backup file ....
i cant use Analysis services command as i have already discussed there is no sql server agent in the instance of analysis server 2005....and as far...
we are using sql server 2005 standard edition ! thanks for the reply Yukon DBA
Hi all, Is it true that connections to the OLAP server can only be made using a Windows Account? Is there a way to setup those connections to the...
I need to copy the security groups from production to stage ,as users are not able to access the cube online... ( note :the production server is...
Hello everybody , I need to create a automation job for 2005 analysis services database to backup a database every night . i dont have sql server...
No matter how many times i try to restore the analysis services database (.abf) on my analysis services instance ...its giving me the following...
Hello everyone , I have been asked to go through Analysis Services databases in development server and see how can i improve the performance of the...
Separate names with a comma.