consolidationquery.blogspot.com
Consolidation Query: March 2012
http://consolidationquery.blogspot.com/2012_03_01_archive.html
Thursday, March 29, 2012. Convert an Access database to SQL. I've seen software that claims it can convert an Access database into SQL one. Does anyone know how this works? Does Microsoft have a solution for this. I've only used Access databases and need to develop one with more power. For developing all I need is the developers edition right? My hosting server does have SQL. Thanks for helping a SQL newbi. JoyceAccess has an Upsizing Wizard to migrate an Access database. My hosting server does have SQL.
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...
drilldownslow.blogspot.com
Drill down slow: March 2012
http://drilldownslow.blogspot.com/2012_03_01_archive.html
Thursday, March 29, 2012. I need to setup repliaction between A and B. I have high transaction /min count. Some tables have TEXT columns. This is what i am planning to do:. Example: table name is CREDITS. Vertical partition the table into two. First table (will be called CREDITS PRI) holds PK column and non TEXT columns, second table (will be called CREDITS SEC) holds PK column and TEXT columns. How do other companies handle this? Thank you in advance for pointing me into the right direction. I have buil...
gettablesize.blogspot.com
get table size: How reliable is Microsoft's type4-JDBC driver for MsSQL Server?
http://gettablesize.blogspot.com/2012/03/how-reliable-is-microsofts-type4-jdbc.html
Thursday, March 29, 2012. How reliable is Microsoft's type4-JDBC driver for MsSQL Server? I am using MsSQLServer in the backend and java in the front-end. How reliable Microsoft's type4-JDBC driver for MsSQL Server? I am very afraid as its only a beta version and version 1.0 and my project is a commercial one. Is there any other better type4-JDBC driver for MsSQLServer available -which i can get for no cost-free of cost. Please guide me. I am not going to use Microsoft's type4-JDBC driver for MsSQL Server.
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?