accessthesqlserver.blogspot.com
access the Sql server: how to auto restart the merge agent
http://accessthesqlserver.blogspot.com/2012/03/how-to-auto-restart-merge-agent.html
Friday, March 30, 2012. How to auto restart the merge agent. I have a merge replication, the merge agent job failed with:. Could not retrieve generation information at the Subscriber. NOTE: The. Step was retried the requested number of times (10) without succeeding. The. The merge agent job failed. The merge process could not retrieve generation. Information at the Subscriber. NOTE: The step was retried the requested. Number of times (10) without succeeding. The step failed. [SQLSTATE 42000]. How to auth...
accessthesqlserver.blogspot.com
access the Sql server: how to audit local access to sql server
http://accessthesqlserver.blogspot.com/2012/03/how-to-audit-local-access-to-sql-server.html
Friday, March 30, 2012. How to audit local access to sql server. I am looking for a way to audit only local access to sql server 2000. That is, I don't care about networked clients logging in to database, I. Want to know everything that a user does who logs in at the local. Is there a way to do this without buying an agent? Can c2 auditing be. Specific and ignore all remote access and only log the local sql server. I don't want to get swamped in a deluge of *all*. Jasper Smith (SQL Server MVP). Activity ...
displaysqlserver.blogspot.com
display SQL Server: March 2012
http://displaysqlserver.blogspot.com/2012_03_01_archive.html
Friday, March 30, 2012. How do I move a web assistant job? I'm bringing up a replacement production SQL 7 server and I've got a few. Web Assistant jobs that create web pages on the old server. I want to. Script them out and automatically move them, but they keep failing on the. Create web page step. Is there any way to transfer these jobs with out. Going through the wizards? AceIIRC, They should be stored as a job. Look for the sp makewebtask job steps. MCT, MCSD, MCDBA. Going through the wizards? I'...
accessthesqlserver.blogspot.com
access the Sql server: March 2012
http://accessthesqlserver.blogspot.com/2012_03_01_archive.html
Friday, March 30, 2012. How to auto start mssql service in command line? Could anyone tell, the way to automatically startup SQL. Server service and SQL Agent at mid-night in command line. In SQL Server 2000? I tried to startup with command servr.exe in Binn. Directory and seems like it stop the Launched startup. Procedure 'sp MScleanupmergepublisher'. How can I startup. SQL Server service without single user mode? Http:/ www.aspfaq.com/. Reverse address to reply.). In SQL Server 2000? In SQL Server 2000?
transferdatafromacces.blogspot.com
transfer Data From Acces: March 2012
http://transferdatafromacces.blogspot.com/2012_03_01_archive.html
Friday, March 30, 2012. How Do I Automate A Recovery Process With Lots of Transaction Logs. I have to automate a process that will restore the latest BAK file and all the TRN files that occured afterwards on a remote server. I can't use the log shipping process. The BAK file is created nightly, and TRN files are created every 15 mins. I'm using a maintenance plan, so the file names change. Can anyone think of a good way to recover all those files, without all the clicking and typing. Jeff Zuerlein Jeff,.
transferdatafromacces.blogspot.com
transfer Data From Acces: How do I adjust the tab settings in SQL Server Enterprise Manager.
http://transferdatafromacces.blogspot.com/2012/03/how-do-i-adjust-tab-settings-in-sql.html
Friday, March 30, 2012. How do I adjust the tab settings in SQL Server Enterprise Manager. I found how to adjust the tab settings when editing a stored procedure using. Query Analyzer, but I don't see any way to adjust the tab settings when. Editing a stored procedure using SQL Server Enterprise Manager. Does anyone know how to do this? VernThere isn't. That dialog is only really appropriate for viewing the code or. Copying it. You should use Query Analyzer to edit and will find the task is. How do I app...
transferdatafromacces.blogspot.com
transfer Data From Acces: How do I attach database when I just have express edition
http://transferdatafromacces.blogspot.com/2012/03/how-do-i-attach-database-when-i-just_30.html
Friday, March 30, 2012. How do I attach database when I just have express edition. I'm trying to attach a database to sql server using the sp attach db. Stored procedure. However, I don't see management studio on my. Computer. I do have Visual Basic 2005, which is supposed to install. The express version of SQL Server. How do I run the command to attach. The database given that I don't have a paid-for version of sql server? MarvinTry using the utility SQLCMD.EXE. COHENMARVIN@.lycos.com" wrote:. The datab...
transferdatafromacces.blogspot.com
transfer Data From Acces: How do I administer SqlServer 2005
http://transferdatafromacces.blogspot.com/2012/03/how-do-i-administer-sqlserver-2005.html
Friday, March 30, 2012. How do I administer SqlServer 2005. I just installed SqlServer 2005 developer edition and I cant find any way. To administer it. There is a "Sql Server Configuration Manager" in the menu. But nothing like the Enterprise Manager in SqlServer 2000. What am I missing? David at windward dot net. Http:/ www.windwardreports.com. Cubicle Wars - http:/ www.windwardreports.com/film.htm. You are missing SQL Server Management Studio. Arnie Rowland, Ph.D. Westwood Consulting, Inc. David Thiel...