i have written a batch file to backup sql server database and it holds the data of CRE.the batch file is running successfully. but, after running i am unable to login to CRE (cash register express). i doubt if my batch file is corrupting my database please answere me what may be the problem
Answer Question | March 6, 2009 9:42 AM
Batch file to backup, Batch files, Cash Register Express, SQL Server 2000 backup, SQL Server development
What are basic differences between SQL Server 2000 and 2005?
Answer Question | January 25, 2012 9:40 AM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don’t want to stop it and lose consistency between disaster recovery and the production copy. How can we [...]
Answer Question | March 6, 2009 4:56 PM
Disaster Recovery, Disaster recovery (DR) testing, Disaster Recovery Database, Disaster recovery planning, Log Shipping, SQL Server, SQL Server databases
I’m using log shipping for my DR. When I want to test my DR, I need to access my DR database and do my tests (and modify it). My problem is I don’t want to stop my log shipping and lose integrity between my prod DB and DR DB. I’m looking for a solution to [...]
Answer Question | March 4, 2009 3:00 PM
Data Recovery, Log Shipping
I have a SQL Server database of customers that called our company, and now i want to prepare a report that indicates which ones are new to our database. How would I do this?
Answer Question | March 4, 2009 7:52 PM
SQL Server database, SQL Server Report Builder, SQL Server reporting, SQL Server Reports
How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?
Answer Question | March 3, 2009 7:47 PM
Oracle, Oracle queries, SQL Server databases, SQL Server Query
An interesting question asked to me. We always mention, we can do lots of things inside a SQL Server Stored Procedure. But does anyone know what cannot be done inside a SQL Server Stored Procedure?
Answer Question | April 10, 2009 7:03 PM
SQL Server stored procedures
I have added the “domain admin” group to the Sql Server, and set permission as “Deny” to connect to the database engine. All employees of this group can still select from any table. The sql server “public” role does not have any permissions on any database table. The “domain admin ” group has local admin [...]
Answer Question | March 2, 2009 8:28 PM
SQL Server, SQL Server permissions, SQL Server security, SQL Server tables
Hi I read through your tip on Processing XML files with SQL Server functions. It’s great but what happens when the XML file exceeds 4000 charcters? I’m using SQL Server 2005 and the XML file that I try and import is too big. Do you have any ideas to how I can use SQL to [...]
Answer Question | March 2, 2009 1:43 PM
SQL Server 2005, SQL SERVER 2005 XML, SQL Server Functions, XML, XML Files in SQL Server 2005
how to restore sql 2000 backup file
Answer Question | March 2, 2009 5:58 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server backup
i am working on FINGERPRINT RECOGNITION SYSTEM, i am using vb.net as front end and sql server 2000 as back end, i had saved fingerprint images in sql server using image datatype, now i need suggestion how to compare fingerprint images.
Answer Question | April 2, 2010 7:36 PM
.NET development, Authentication, Biometric authentication, Biometrics, Fingerprint authentication, Fingerprint scanning, SQL Server 2000, VB.NET, Visual Basic .NET
I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = ’0′ CONNECT BY PRIOR a.parentid = a.sid’ Where I have ’0′ in the query above, should take all the values from PID. Is there a easy way [...]
Answer Question | March 2, 2009 4:05 PM
Oracle development, Oracle queries, SQL, SQL queries, SQL Server connectivity
We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting “Restore Database”, Enterprise Manager runs remarkably slow. I’m sure we could run the restore through a [...]
Answer Question | February 27, 2009 4:34 PM
Enterprise Manager, SQL Enterprise Manager, SQL Restore, SQL Server 2000, SQL Server performance
I need to convert my Sybase data to SQL Server data. I tried using several methods for a single table that contains 1357 records. When I used the DTS wizard, the tranfer completed sucessfully but the data in the column with data type “money” was not correctly transferred. For an example, the value 9700.00 was [...]
Answer Question | February 27, 2009 3:41 PM
DTS Import/Export Wizard, DTS Wizard, SQL Server, Sybase
Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?
Answer Question | February 27, 2009 3:34 PM
Database mirroring, SQL Server 2005, SQL Server database, SQL Server Database Mirroring, VPN routers
I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?
Answer Question | May 20, 2011 3:33 PM
LDF, MDF, SQL Server 2005
I have an existing Crystal Report that uses a Stored Procedure as a datasource. The requirements have changed and the Procedure has been updated to have only one parameter instead of two. How do I refresh the Stored Procedure without removing it. I have tried to Verify the Database but just get an error stating [...]
Answer Question | February 27, 2009 4:12 AM
Crystal Reports, SQL Server, SQL Server stored procedures, Stored Procedures
Can SQL 2005 DB mirroring work if the mirror server is to be in another building (building networks connected via VPN router)? We just want employees to be able to remote into the mirror server from home if power is lost at the main building.
Answer Question | February 26, 2009 4:50 PM
SQL, SQL database replication, SQL Server Database Mirroring, VPN
Hi, I’m using SQL Server Agent which is running on SQL Server 2000. My question is, is there a way to give permissions to users to simply view the jobs and not change/execute them? I’ve read that this is possible in SQL 2005 with SQLAgentReaderRole, but what about 2000? Thanks in advance.
Answer Question | February 26, 2009 3:50 AM
SQL Server 2000, SQL Server Agent, SQL Server Agent job permissions, SQL Server user permissions, SQLAgentReaderRole
My problem is regarding SQL Server 2000. Whenever I try to access SQL Server Enterprise Manager, I am told that the disk is full, along with the tempdb log. I tried to shrink the database, but for some reason I am not able to do so. Can you help me?
Answer Question | February 25, 2009 8:48 PM
SQL Server 2000, SQL Server Database Shrinking, SQL Server databases, SQL Server Enterprise Manager