Migrating from MS Access to SQL Server Express
Microsoft has an upgrade advisor available on thier website to assist in migrating from Access to SQL Server. You can find the upgrade advisor <a href=”http://www.microsoft.com/sql/solutions/migration/default.mspx”>here</a>.
View Answer
| April 18, 2008 6:27 PM
Microsoft Access, SQL Server Express Edition, SQL Server migration
Microsoft has an upgrade advisor available on thier website to assist in migrating from Access to SQL Server. You can find the upgrade advisor <a href=”http://www.microsoft.com/sql/solutions/migration/default.mspx”>here</a>.
View Answer
| April 18, 2008 6:27 PM
Microsoft Access, SQL Server Express Edition, SQL Server migration
Looking for a stored procedure to monitor size of Transaction Log file
Yes you can monitor this by looking at the size column in the sysfiles table (SQL 7/2000) or the sys.database_files DMV (SQL 2005+). This column is in pages, so take this number and multiply by 8 to get the file size in Kb. Then divide by 1024 to get Megs. Then if the value is [...]
View Answer
| April 18, 2008 6:23 PM
SQL Server availability, SQL Server stored procedures, SQL Server transaction logs
Yes you can monitor this by looking at the size column in the sysfiles table (SQL 7/2000) or the sys.database_files DMV (SQL 2005+). This column is in pages, so take this number and multiply by 8 to get the file size in Kb. Then divide by 1024 to get Megs. Then if the value is [...]
View Answer
| April 18, 2008 6:23 PM
SQL Server availability, SQL Server stored procedures, SQL Server transaction logs
How to work with Visual Basics 6.0 and SQL Server 2000
The most secure method for adding and deleting data is through <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-stored-procedures-the-work-horse-of-the-database/”>stored procedures</a>. These will allow you to add, and process data, as well as retreive data from the database. The <a href=”http://itknowledgeexchange.techtarget.com/sql-server/tag/back-to-basics/”>Back To Basics</a> series on my blog should provide you with some good info. This <a href=”http://www.freevbcode.com/ShowCode.Asp?ID=3687″>sample code</a> shows how to use [...]
View Answer
| April 18, 2008 6:19 PM
SQL Server 2000, SQL Server integration/interoperability, VB, Visual Basic
The most secure method for adding and deleting data is through <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-stored-procedures-the-work-horse-of-the-database/”>stored procedures</a>. These will allow you to add, and process data, as well as retreive data from the database. The <a href=”http://itknowledgeexchange.techtarget.com/sql-server/tag/back-to-basics/”>Back To Basics</a> series on my blog should provide you with some good info. This <a href=”http://www.freevbcode.com/ShowCode.Asp?ID=3687″>sample code</a> shows how to use [...]
View Answer
| April 18, 2008 6:19 PM
SQL Server 2000, SQL Server integration/interoperability, VB, Visual Basic
Problem occuring while performing Mirroring
That is the way it is supposed to be. The database on the mirror server can not be accessed as data is being fed into it in real time. If you need to access the database, you can try creating a snapshot of the database. This will be a static read only copy of the [...]
View Answer
| April 18, 2008 12:29 AM
Database mirroring, SQL Server, SQL Server 2005
That is the way it is supposed to be. The database on the mirror server can not be accessed as data is being fed into it in real time. If you need to access the database, you can try creating a snapshot of the database. This will be a static read only copy of the [...]
View Answer
| April 18, 2008 12:29 AM
Database mirroring, SQL Server, SQL Server 2005
alert log file to monitor disk space
You will want to schedule transaction log backups to occur on a regular schedule. This will keep the transaction logs from growing to large. If you don’t need to be able to do a point in time restore then you can change the database recovery option from FULL to SIMPLE.
View Answer
| April 17, 2008 11:53 PM
BizTalk, Disk quota management, SQL Server
You will want to schedule transaction log backups to occur on a regular schedule. This will keep the transaction logs from growing to large. If you don’t need to be able to do a point in time restore then you can change the database recovery option from FULL to SIMPLE.
View Answer
| April 17, 2008 11:53 PM
BizTalk, Disk quota management, SQL Server
New user permission to SQL server
Are you sure that you have entered the username and password correctly? What information is in the errorlog? Please post the entire log entry.
View Answer
| April 17, 2008 8:08 PM
SQL registration properties, SQL Server, SQL Server errors
Are you sure that you have entered the username and password correctly? What information is in the errorlog? Please post the entire log entry.
View Answer
| April 17, 2008 8:08 PM
SQL registration properties, SQL Server, SQL Server errors
SQL Server 2005 – Are There Any Easy Appl. Builders
Have you tried using Microsoft Access shipped with the Microsoft Office? You can connect to SQL Server via ODBC and build simple forms very easily. Hope this helps. Michelle.
View Answer
| April 16, 2008 3:45 PM
Database connectivity, Database frontend, SQL Server 2005
Have you tried using Microsoft Access shipped with the Microsoft Office? You can connect to SQL Server via ODBC and build simple forms very easily. Hope this helps. Michelle.
View Answer
| April 16, 2008 3:45 PM
Database connectivity, Database frontend, SQL Server 2005
Replication
You asked the same question twice so: yes and yes. Michelle.
View Answer
| April 16, 2008 3:32 PM
SQL database replication, SQL Server, SQL Server administration
You asked the same question twice so: yes and yes. Michelle.
View Answer
| April 16, 2008 3:32 PM
SQL database replication, SQL Server, SQL Server administration
fore front – Can FCS be installed on sql express 2005
FCS cant be installed on sql express 2005 only std or above
View Answer
| April 15, 2008 4:52 PM
FCS, Forefront Client Security, SQL Server Express Edition
FCS cant be installed on sql express 2005 only std or above
View Answer
| April 15, 2008 4:52 PM
FCS, Forefront Client Security, SQL Server Express Edition
Data Migration Betrieve Tables to MS SQL Server 2005
What to prepare if we are going to migrate instead…. or what are the steps that we should take. Thanks. correcting and adding my posted question. ————————- I have several Btrieve databases being pulled into SQL 2005 via SSIS. Basically you will need to create a connection into the database (ODBC is best here in [...]
View Answer
| April 15, 2008 8:27 AM
Data migration, Database migration, Migration, Pervasive, SQL Server 2005, SQL Server migration
What to prepare if we are going to migrate instead…. or what are the steps that we should take. Thanks. correcting and adding my posted question. ————————- I have several Btrieve databases being pulled into SQL 2005 via SSIS. Basically you will need to create a connection into the database (ODBC is best here in [...]
View Answer
| April 15, 2008 8:27 AM
Data migration, Database migration, Migration, Pervasive, SQL Server 2005, SQL Server migration
about checkbox
If you are trying to put this into a field with a data type of BIT (which would be the database equivalent of boolean) then you have to put in a 0 or a 1. These are the only two values which a field of the BIT data type supports. 0 = No, 1 = [...]
View Answer
| April 15, 2008 12:46 AM
CheckBox, SQL Server, VB.NET, VB.NET 2005, Visual Basic .NET
If you are trying to put this into a field with a data type of BIT (which would be the database equivalent of boolean) then you have to put in a 0 or a 1. These are the only two values which a field of the BIT data type supports. 0 = No, 1 = [...]
View Answer
| April 15, 2008 12:46 AM
CheckBox, SQL Server, VB.NET, VB.NET 2005, Visual Basic .NET
Error when restoring a .bak file in SQL Server
How did you restore the database, with T-SQL command or through SSMS? This error is likely to occur when network is unstable. But in your case it looks you’re restoring a local database to the same server from a local backup. Have you checked the path and the “replace” option? If you used SSMS, please [...]
View Answer
| October 23, 2012 1:04 AM
Backup & recovery, SQL Server backup, SQL Server errors
How did you restore the database, with T-SQL command or through SSMS? This error is likely to occur when network is unstable. But in your case it looks you’re restoring a local database to the same server from a local backup. Have you checked the path and the “replace” option? If you used SSMS, please [...]
View Answer
| October 23, 2012 1:04 AM
Backup & recovery, SQL Server backup, SQL Server errors
Looking to resolve SQL Server performance problems caused by using many temporary tables
Yes, a RAM disk would provide you with an ultra fast tempdb, however there are very few databases which actually need this sort of speed boost. Purchasing enough RAM to be able to create a RAM disk large enough to fit your needs may get very expensive. Once you start needing to use the 4 [...]
View Answer
| April 11, 2008 8:05 PM
Disk storage, SQL Server 2000, SQL Server performance tuning
Yes, a RAM disk would provide you with an ultra fast tempdb, however there are very few databases which actually need this sort of speed boost. Purchasing enough RAM to be able to create a RAM disk large enough to fit your needs may get very expensive. Once you start needing to use the 4 [...]
View Answer
| April 11, 2008 8:05 PM
Disk storage, SQL Server 2000, SQL Server performance tuning
Restoring a SQL Server 2005 database from a public share backup
No that is not correct. You have been able to restore from a network share as far back as SQL 7 (and probably further back). The UI (Enterprise Manager and Management Studio) will only show you the local drives on the SQL Server. However if you use the RESTORE DATABASE command you can specify a [...]
View Answer
| April 11, 2008 7:58 PM
Backup & recovery, Disk storage, SQL Server, SQL Server 2005, SQL Server backup
No that is not correct. You have been able to restore from a network share as far back as SQL 7 (and probably further back). The UI (Enterprise Manager and Management Studio) will only show you the local drives on the SQL Server. However if you use the RESTORE DATABASE command you can specify a [...]
View Answer
| April 11, 2008 7:58 PM
Backup & recovery, Disk storage, SQL Server, SQL Server 2005, SQL Server backup
How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005
If you selected the Save Package option at the end of the wizard you can import that package into a BIDS project and then edit it. If you saved the package to the SSIS server you’ll need to export the package first. Connect to the SSIS server with Management studio. In the Object explorer select [...]
View Answer
| April 11, 2008 6:03 PM
Copy Database Wizard, SQL Server 2005, SSIS
If you selected the Save Package option at the end of the wizard you can import that package into a BIDS project and then edit it. If you saved the package to the SSIS server you’ll need to export the package first. Connect to the SSIS server with Management studio. In the Object explorer select [...]
View Answer
| April 11, 2008 6:03 PM
Copy Database Wizard, SQL Server 2005, SSIS
How to back up SQL Server database file on a different shared network
I know that SQL server has built in log shipping and 2005 has some improved mirroring capabilities but not sure that is going to get you what you want. I have used Double-Take software hundreds of times to replicate multiple SQL databases and log files to WAN locations several thousands of miles apart. Then the [...]
View Answer
| April 10, 2008 1:40 PM
SQL Server backup, WAN
I know that SQL server has built in log shipping and 2005 has some improved mirroring capabilities but not sure that is going to get you what you want. I have used Double-Take software hundreds of times to replicate multiple SQL databases and log files to WAN locations several thousands of miles apart. Then the [...]
View Answer
| April 10, 2008 1:40 PM
SQL Server backup, WAN
Activesync And Server 2000
Based on the information provided, it appears that you are trying to synchronize a Pocket PC style phone with Exchange 2000 Server. You cannot do this with Exchange 2000 Server alone, you also need Mobile Information Server. This dependency is done away with in Exchange Server 2003 and higher. Upgrading to Exchange Server 2003 is [...]
View Answer
| April 9, 2008 2:05 PM
Exchange, Exchange Server ActiveSync, Microsoft Mobile, Mobile email, Server 2000
Based on the information provided, it appears that you are trying to synchronize a Pocket PC style phone with Exchange 2000 Server. You cannot do this with Exchange 2000 Server alone, you also need Mobile Information Server. This dependency is done away with in Exchange Server 2003 and higher. Upgrading to Exchange Server 2003 is [...]
View Answer
| April 9, 2008 2:05 PM
Exchange, Exchange Server ActiveSync, Microsoft Mobile, Mobile email, Server 2000
Microsoft SQL 2005 Networking
First you should make sure that the two PCs know eachother on the Ethernet, so ping one another and see if you get a reply (open the DOS prompt and ping <machine name> ). If this works then you might have a problem with permissions, so – either you use a Domain account that has [...]
View Answer
| April 9, 2008 1:27 PM
C, SQL Server 2005
First you should make sure that the two PCs know eachother on the Ethernet, so ping one another and see if you get a reply (open the DOS prompt and ping <machine name> ). If this works then you might have a problem with permissions, so – either you use a Domain account that has [...]
View Answer
| April 9, 2008 1:27 PM
C, SQL Server 2005
How to add row to a SQL Server table where username can be inserted
You’ve got a couple of options. 1. Setup a default constraint on the table which puts the value of the suser_sname() function into the column. This will put the name of the person who inserted the row into the table, providing that they do not statically put a value into the column. 2. If the [...]
View Answer
| April 9, 2008 12:24 AM
SQL Server 2005
You’ve got a couple of options. 1. Setup a default constraint on the table which puts the value of the suser_sname() function into the column. This will put the name of the person who inserted the row into the table, providing that they do not statically put a value into the column. 2. If the [...]
View Answer
| April 9, 2008 12:24 AM
SQL Server 2005
What are the best practices for storing SQL Server application/program files on a SAN?
Putting the actual EXEs on the SAN shouldn’t really be a problem. I generally prefer to put them on local storage as local storage is cheaper than SAN storage. As SQL shouldn’t be reading from them very often except on starting the service it shouldn’t be a problem. If the system isn’t in production I’d [...]
View Answer
| April 9, 2008 12:20 AM
SAN, SQL Server, Storage Area Networks
Putting the actual EXEs on the SAN shouldn’t really be a problem. I generally prefer to put them on local storage as local storage is cheaper than SAN storage. As SQL shouldn’t be reading from them very often except on starting the service it shouldn’t be a problem. If the system isn’t in production I’d [...]
View Answer
| April 9, 2008 12:20 AM
SAN, SQL Server, Storage Area Networks
