Hi I need to create a User DSN based on SQL Server driver under Data Sources (ODBC). As I need to do it on multiple PCs, is there a script or another automated way to do this quickly? Thanks Regards ...more >>

I am a real newbie to SQL Server and believe this should be my solution. I have an access 2007 database which I had originally wanted to make available for all, however, given the lack of speed on this database, I was thinking that SQL Server Express would be my solution to get the data quick...more >>

Hello-- Recently installed SQL Server 2005 Std. Ed. on Windows Server 2003 SP1. Server is AD domain controller. Tried installing SP2 for SQL 2005--no difference. Am seeing this error over and over: The connection has been dropped because the principal that opened it subsequently assumed...more >>

I'm running a sql statement in code: strSQL = "SELECT tblCustomerMaster.* " _ & "FROM tblCustomerMaster;" docmd.runsql strsql This is a front end to a 2000 sql server using odbc and I keep getting the error ...can't find the field '|' referred to in your expression. Any ideas how to c...more >>

How to delete the achieve server log file in SQL 2000 SP4 ...more >>

I need some info about how to handle sql logs ...more >>

Using SQLEXPRESS, is transaction logging available? Maybe I'm just not looking in the right place... ...more >>

We've just started migration from SQL Server 2000 to 2005. One question that's come up, and I can't seem to find the answer.. Using the Management Studio. We can answer the question "What are the user permissions on this table?" by getting the properties of the table and selecting Permiss...more >>

I am trying to install developer edition on Vista. I went to programs/features and turned on IIS (all features). When I run the setup for SS 2005 I get a message that IIS is not installed. I need to use Reporting Services....more >>

Hi Is there a way to dump all the sql server data into some sort of file that can be imported into a local sql server later? I have used sql server dumper but it is not very stable and crashes during sump. Thanks Regards ...more >>

Hi, Could someone tell me if a free load generation/simulator exists for SQL 2005? We are doing some power measurements with Intel E5310s and I would really like to give the processor and disks a bit of a run. Thanks Matthew ...more >>

We have SQL 2005 EE version. MS CRM 3.0 Professional supports data mining. Do I need to have Analysis Services feature installed in SQL2005 in order for CRM 3.0 to work with data mining? Also, anybody knows why SQL 2005 EE doesn't provide any management interface to the database after the...more >>

Anybody knows how to get the tab group back in SQL Server managemnet Studio? I did something and now I can only tile the windows, or cascade them. I can't get the tabs back. The on-line docucmentaion doesn't tell you how to do this. Thanks, Gilgamesh ...more >>

if you are tracking historical dates in an sql db -- is the strategy to apply a character datatype to the field? -- since the datetime field ranges January 1, 1753, through December 31, 9999 And what if you don't need the time as part of a date field? ...more >>

I have sites that I need to convert from php/mysql to asp/mssql 2005. Is there a conversion utility for the database? Thanks. -- ...more >>

I have a Client table, with a field StartDate I also have a Sales table. There is a field called SaleDate. I'd like to run a query, and flag any Sales within one year of the Clients start date as New Business. I thought I'd just this would be easy - use DateDiff, but I was wrong! For example...more >>

I received a SQL 2005 disk with my purchase of Visual Studio 2005. It says developer edition and when i load the CD it will give me 3 options of installation x86 and x64 the third option I know doesn't work for me, however what option do I select to install and is this a full blown version of ...more >>

Hello, I have these tables ITM_Order_SerialNr OrderNo SerialNo FieldId FieldValue ITM_NamePlateData OrderNr SerialNr ParamId ParamValue ITM_MarkVariables OrderNo SerialNo FieldId FieldValue I have used this query to fill ITM_MarkVariables INSERT ITM_MarkVari...more >>

Hi! I am a beginner in SQLsrv! I have a SQLSrv2000 database with tables with up to 200000 rows in several tables. Must of the times I am just reading some data and thats no problem. But now I whant to build an importfunction where I am reading up to 25000 rows from a Excelfile, I am firs...more >>

When I try to backup a SQL 2000 database I recieve the following error in the output log. Any ideas? Thank you. SQL 2000 w/ SP4 [39] Database SolRounder: Database Backup... Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK] [Microsoft SQL-DMO (ODBC SQLState: 42000)] Erro...more >>

I'm a one day newbie to sql server and need some pointers. I have a production server and a testing server. I'm looking at both my production and testing servers using the Microsoft SQL Server Management Studo console. I need to get a copy of a database from the production to the testing, ...more >>

Hi Can I create a DB in SQL 2000 and then attach it to the SQL 2005 express or vice versa. Do you forsee any problems with this. Thanks. Regards Mohamed Ali ...more >>

The following message appeared on my screen after I tried to get my password from an on-line site: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" Does anyone know what it means and how...more >>

I have the following values in a field named (sn_font). Opaque=1;Font=Times New Roman;FontSize=10;FontBold=0;FontItalic=0;FontUnderline=0;TextColor=0,0,0;BackColor=255,255,204;Printable=1 I need to make a select statement that will give a result such as "0". If I need to select only the...more >>

My new Dell laptop came with SQL Server 2005 preinstalled but I can't get it to run. When I attempt to start it I get the following error messages: SQL Server - Error code 17058 Active Directory Helper - Error code 1073741724 The error logs show the following: MSSQLServer AD Helper - "0...more >>

Environment: SQL 2000 Standard SP4 Database recovery mode: Simple I have a stored proc that once a day transfers a large amount of data (2+ million rows usually) from one table to another as follows: INSERT INTO table1 SELECT * FROM table2 DROP table2 This doesn't scale well obviously...more >>

Hi Is there an easy way to drop all object of a db so it is as new? Just so I can run a script to recreate the objects. Thanks Regards ...more >>

Hi, Anytime I start the PC the following message appears: "SQLWriter SQLDUMPER library failed initialization. Your installation is eitehr corrupt or has been tampered with. Please uninstall then re-run setup to correct this problem." Any idea how to resolve it? best, enno...more >>

I have installed an .sdf database (consisting of two tables right now) and I want to create a front end, ideally using Visual C++ but I also want to learn C#. I have created Windows projects in both and attempt to create a new database connection, however both are looking for an mdf file even ...more >>

Hello. I have been avoiding this problem for over a year, using a messy work-around, and now need to find a way to create this query. I hope someone will be able to help me make it work. tblStores is a listing of stores using StoreID as the key. tblSales uses StoreID as its key, also, ...more >>

Hi all, I am trying to give access to a windows user to be able to run queries against a SQL 2005 db - The Windows user can login to the SQL server via RDP and login to SQL no problem, and the SA user can run queries remotely via query analyzer etc, but the windows user get a login failed i...more >>

I have an application that uses SQL 2005 EE as the database manager ( ACT 2007 SAGE ) To share the ACT db with multiple users i need to install the whole package on a "server"* I have been told that the "server" cannot have MSSQLServer on ( any flavor) because SQL2005EE is not compatabl...more >>

Hi All, I have a question; I want to learn and SQL, but I don’t know where to begin. I started some books and found either they are too advanced or not focused on database administration or SQL server it's self. My background is in AD and server support, I am in the middle of a disaster ...more >>

I'm trying to make a file file as a subfolder and then use bcp to save some files in that folder. I'm not sure how to chdir to that main folder and then make a subfolder. Here's what I've been trying: CREATE PROCEDURE [sp_LauferMkDir] AS DECLARE @strMO [char](20) DECLARE @strDay [ch...more >>

Hello, I need to overwrite the sql Express with the Enterprise version. Will I loose the users / dbs configuracions? TIA Tony ...more >>

Hi, I downloaded a 180 days trial version of sql 2005 and I don't remember the day I installed it. HOWTO find out how many days I have left? TIA Ana ...more >>

I have an Excel workbook with VBA coded Insert Into statment to upload data to SQL Server. I'm having a problem with the syntax for creating a line continuation in my SQL Insert Into statement. I need to add some Field Names to the statement, but I've reached the max length of the statemen...more >>

I have a few fairly complex jobs set up that drop indexes, run DTS packages, rebuild indexes and so on. Is there a way I can call these jobs from another job, or do I have to build a 'super job'? ...more >>

I'm trying to write a sp using the bcp - most from an example - and it's not producing a file.Here's what I have: CREATE PROCEDURE sp_LauferFileNameOut AS DECLARE @FileName varchar(50), @bcpCommand varchar(2000) SET @FileName = REPLACE('c:\LauferOut_'+CONVERT(char(8),GETDAT...more >>

Somewhere along the line Microsoft installed SQLserver on my Windows XPSP2 Home and a couple of days ago downloaded and installed a critical update for it. Now my computer is really slow and I keep getting programs not responding. Do I need this, whatever it is??? Please tell me I don't ne...more >>