SQL Server 2005 – Are There Any Easy Appl. Builders
Hi, Is there a easy application builder for a PC to access a SQL Server 2005 Database that will give it the ability to do Inserts, Update, and Deletes? Is there a program that can read in a SQL Server 2005 Schema and generate forms to do updates and reporting? Are there any Open Source [...]

Answer Question   |  April 16, 2008  6:35 AM
Database connectivity, Database frontend, SQL Server 2005

New user permission to SQL server
Hi all, I have created a new local user on the sql server. Now when i access the sql enterprise server, it fails and gives error as ” login failed to user, check SQL registration properties. Thank you.

Answer Question   |  April 17, 2008  6:34 AM
SQL registration properties, SQL Server, SQL Server errors

How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005
Hello, I recently read Jeremy Kadlec great article titled, “Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard” at http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html. Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I can’t find out how to [...]

Answer Question   |  April 11, 2008  3:56 PM
Copy Database Wizard, SQL Server 2005, SSIS

Scheduled job for Oracle 9 returning ORA-01858
We have an Oracle 9.2.0.1.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error. Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the Scheduler is running, two of them have [...]

Answer Question   |  August 4, 2010  3:05 PM
ORA-01858, Oracle 9, Oracle Scheduler, Stored Procedures

Potential over & under security issues with SQLNative Client ?
Hello, I’ve been unable to find any reports of these two problem when using the SQL Native Client driver (9.00.3042.00), so I’m hoping else has seen these. Firstly check constraint definitions accessed by the following TSQL only returns data with the SQL Server driver, ie nothing with SQL Native Client. Permissions are the same, just [...]

Answer Question   |  April 10, 2008  6:43 AM
SQL Server, SQL Server security, T/SQL

Restoring a SQL Server 2005 database from a public share backup
Is it true that even in SQL Server 2005 you cannot restore a database from a backup on a public share, but ONLY from a local storage (DASD)drive?

Answer Question   |  April 11, 2008  2:35 AM
Backup & recovery, Disk storage, SQL Server, SQL Server 2005, SQL Server backup

Looking to resolve SQL Server performance problems caused by using many temporary tables
I need your advice on the SQL Server performance tuning. The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site. “RamDisk presents a powerful solution to this problem by providing up to 63 GB [...]

Answer Question   |  April 14, 2008  2:23 AM
Disk storage, SQL Server 2000, SQL Server performance tuning

Error when restoring a .bak file in SQL Server
I’m having a problem restoring a .bak file in SQL Server. The .bak file is fine and good. But when I restore it, I get an error. It says ” TITLE: Restore failed for Server <servername>(Microsoft.SqlServer.Smo) —————————— ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Directory lookup for the file “C:Temp<databasename>.mdf” failed with the operating system error 2(The system cannot [...]

Answer Question   |  April 12, 2008  2:12 AM
Backup & recovery, SQL Server backup, SQL Server errors

How to back up SQL Server database file on a different shared network
I want to back up a SQL Server database file on a different system shared folder which is in different WAN network. How can I do this and are there any other backup methods available in SQL Server?

Answer Question   |  April 10, 2008  2:06 AM
SQL Server backup, WAN

Microsoft SQL 2005 Networking
Hi I’m a software developer and i use Visual C# 2005 and Microsoft SQL 2005 to create my desktop applications my application is a software will be installed in to client machines as 2 home PC and i want to make the two software’s connect throw Ethernet to my database which it located on one [...]

Answer Question   |  April 10, 2008  7:53 AM
C, SQL Server 2005

How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel
I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know how to actually design an [...]

Answer Question   |  April 9, 2008  11:30 PM
Microsoft Access, SQL Server integration/interoperability, SSIS, Stored Procedures

When designing a data warehouse in SQL Server what is the best setting for the varchar data type?
I am designing a data warehouse database to be implemented in SQL Server. There are a number of variable length character fields for which I intend to use the varchar field type. On previous data warehouse implementations in Oracle, I frequently set the length for the varchar fields higher than the current data length. I [...]

Answer Question   |  April 9, 2008  11:14 PM
SQL Server data warehousing/business intelligence

What are the best practices for storing SQL Server application/program files on a SAN?
We have a non-clustered SQL Server with a Storage Area Network (SAN) on it. What are industry standards/best practices for the location of the application/program files? Is it okay to put the app files on the SAN? We usually put them on local disk storage, but due to an incorrect installation, they wound up on [...]

Answer Question   |  April 9, 2008  10:48 PM
SAN, SQL Server, Storage Area Networks

Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?
Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

Answer Question   |  April 9, 2008  10:38 PM
SQL Server Analysis Services, SQL Server data warehousing/business intelligence, SSAS

How to add row to a SQL Server table where username can be inserted
Say I have a table called “Customer” (SQL Server 2005) and 10 users have access rights to this table. If I want to add a row to this SQL Server table to insert the username who initially modified this row, how can I accomplish that task?

Answer Question   |  April 9, 2008  10:32 PM
SQL Server 2005

fore front – Can FCS be installed on sql express 2005
Can FCS be installed on sql express 2005, and if yes what is the requirements as per the web site it can be done but how !!!!??? eveywhere else they are saying its not supported http://www.microsoft.com/forefront/serversecurity/mgmt/sysreqs.mspx

Answer Question   |  April 15, 2008  12:45 PM
FCS, Forefront Client Security, SQL Server Express Edition

How can I collect database/server information across multiple MSSQL versions.
I would like to collect database info(backups, databases, logins, etc) as well as server information ( MSSQL version, patch level, etc). I would like to use one server to collect information from all of my servers. I have MSSQL 7, 2000, & 2005 on Windows servers 2000 & 2003. I am also new to MSSQL [...]

Answer Question   |  April 8, 2008  6:09 PM
Database, Scripting, SQL Server, Stored Procedures

Great Plains 8 ODBC Error (45)
This just started today, Great Plains has been working for a good time now. I get first error message when logging on ” A get/change first operation on table ‘tablename’ (45).” And then when you click on More Info… it says “[Microsoft][ODBC SQL Server Driver][SQL Server]Database’Databasename’ is already open and can only have one user [...]

Answer Question   |  April 7, 2008  1:47 PM
Database, Great Plains, ODBC, SQL Server errors

alert log file to monitor disk space
I have a sql server which has some Biztalk databases which can grow like wildfire on a daily basis, where log files can grow to 20 gig in an hour. Is there a way to set an alert based upon a log file size growing to big that I can fire an sp on to [...]

Answer Question   |  August 24, 2011  7:35 PM
BizTalk, Disk quota management, SQL Server

How to set up a threshold on a SQL Server 2000 Agent backup job?
I would like advice on setting up a threshold if a SQL Server 2000 Agent backup job (nightly) is running after a certain time (7 a.m. PST), I would like to cancel it.

Answer Question   |  April 4, 2008  2:03 PM
SQL Server 2000, SQL Server Agent, SQL Server backup