Hi, Can we configure sql server 2008 r2 database clustering between blade server and a rack-mounted server?
Hi, I would like to setup Multi Server Administration in our environment. I would like to create a maintenance plan for all the dbs on the master...
Hi, I would like to create a query that runs dbcc loginfo command on all the databases and returns only the no. of rows returned for each database....
Hi, I have configured logshipping for a database. The primary server is in PST and secondary is in EST time zone. I see some false errors thrown from...
Hi, We have reports on development server right now which we want to move to production server. The developers have created the reports on their...
Hi, I find the following error in the error log:DESCRIPTION: SSPI handshake failed with error code 0x8009030c while establishing a connection with...
Hi, We have made files only installation for reporting services on a server with out installing the database on the local server. The report server...
Hi, We have a report server and i would like to set up security and permissions on that. I see that every one is able to access the link and run the...
Hi, We have installed and configured reporting services, we are able to connect to report server url from server however with same user when we try...
Hi, When I am trying to create a new login using GUI on a server and try to serach for the windows accounts i am getting the following error: The...
Hi, I have restored a database from a different server on to a dev server. I see some user accounts in the database and they are not in the logins....
Hi, I would like to copy a flat file from one location to another and rename it. Can i do it in a single step coz I need to execute it as a daily...
Hi, I have a job that emails the history of all the jobs every day. That was working fine untll I changed the sql agent logon from local account to a...
Hi, I need to load data into a table from a flat file. The last row in the flat file contains information about the total number of rows in the file....
HI, I have created an SSIS package to load the data from a flat file into a table. I would like to configure it to wait for few minutes and retry for...
Hi, I have installed new sql server 2005. Do i have to run both SP1 and SP2 after installation. I just installed SP2 and the version shows as SP1:...
Hi, Can someone help me in writting the below stored procedure. I am trying to write a stored procedure that would fulfill the below task. I have...
Hi, I am trying to create a job to mail the backup log after the job is completed. the syntax looks like this: MailSQLLogs.vbs name@company.org none...
Hi, I am trying to create a database in which I can save some Word, Excel, PDF & JPEG files. Could any one help me with some ideas or links which...
Hi, I am trying to create a report on my newly installed sql server 2005 Reporting services. I am followig the tutorial to create a report on...
Separate names with a comma.
