Hello, I have a collection of SQL Scripts that I would like to execute using a batch file from a remote machine. Does anyone have any suggestions? I think that I could use osql or isql, but I have never done that before. I would appreciate any assistance. Stewart ...more >>

Is it possible to create SQL Server Database on SQL Server 2000 with Sparse File attribute set (NTFS drive)?...more >>

hi, I have a question. Maybe You know the equivalent to command LIMIT from MySQL I couldn`t find something like this in MS SQL PS I try to display 10 records begining form e.g. 4 sort by id something like: "SELECT * FROM table WHERE name=... LIMIT 4, 10 ORDER BY id" in MySQL thanx, Urba...more >>

Hi, We are going to impelement Microsoft Solution in our Company(Server 2003, Navision and SQL server) in the company. I am just wondering how many SQL licenses will I need for this. They say that Navision makes some pool and we will need less User licenses for SQL then number of Licenses f...more >>

Do anyone have an simple PHP & MSSQL Script to show me how it works? Please :) ...more >>

I posted the following email to another Win2k Server Networking newsgroup last week but got no response. Perhaps someone monitoring this one can answer my question. If you have a remote office across a very slow WAN link, is there a way to tweak a Win2k server to send SMB traffic optimized w...more >>

Good Day All. I have been trying to find general answers to a very specific question about application design and implementation using DotNet. My situation is that I would like to design and implement a Web Application. I would like to avoid using datasets in favour of the datareader to ...more >>

Hello guys, is it possible to rename a table with a SQL statement ? Thanks ...more >>

Quisiera Saber como puedo controlar y establecer el maximo numero de conecciones de un cliente de SQL Server o de que depende este valor. TEnfo entendiedo que cada coneccion onsume 4 o 40 K de memoria y pues dependiendo del total de la memoria del cliente se podran abrir "N" conecciones. Esto...more >>

Hello there, I have a VB6 application that runs over a SQL Server 2000 Database. Sometimes (most recently) i get the folowing error: Run-time error -2147467259 (80004005) Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447 Expression: m_SizeRec > 0 && m_SizeRec ...more >>

Hello, I am desperatly trying to export a table from my sql server. Using bcp I only have my csv file with . as decimal for all numbers (I also tried the export wizard of the sql console). Is there a way to obtain these figures with a comma , as decimal? The ddl of the table is below and numb...more >>

I've got a SQL Server database. Nearly finished. It's going to go on a single non networked machine. One day somebody might get access to it over ADSL (probably TS), but for now it's a single user no lan. The machine will actually be running the MSDE. Windows XP Home. I'm quite happy, for ...more >>

Greetings ! We're surprise to see no reply to our original question about Object/Relational mappers. So no one as such architecture? We need this for our software since we made such a layer years ago but it doesn't perform as we expected. We're then looking for a commer...more >>

Hi. My application needs to do distributed transaction on remote Sql server.My application can be run from workstations(XP professional) or from SQL server 2000... Limitations for this application are Worksations wont be having SQL server installed. I cannot give administrative righ...more >>

Greetings; We're looking at O/R mapping technologies for being used between our C++ application and SQL Server. We're developping on VC6. We're currently looking at what the following product may offer: "Versant Open Access" Any suggestions ? Other ORM ? Thanks ! ___________________...more >>

I am having problems connecting my analysis server to the DB on the server. In enterprise manager i can find it just fine. Any help would be nice. Thanks TBXML...more >>

Is it possible to update a SQL Server table from Excel? We have some Mac users who have Excel, and need to add data to some tables. -- Greg Stigers, MCSA remember to vote for the answers you like ...more >>

Hello. I have a table with int identity field (X INT IDENTITY(1,1)). I want update SEED value to 4000. I cannot drop column because I have a foreign key to it from other table. How I can do this (update/alter identity's SEED value to column)? ...more >>

hi.. assuming that i have sqlserver on one machine and enterprise manager/query anaylzer on another, can i update them using sql server sp3a (or any service pack?)...more >>

Hi; Does anyone have a .msi program that correctly installs sqldmo, and does nothing if it is already installed? I was going to do this but there are a bunch of details that must be exactly right and I am not an expert with the Visual Studio installer. -- thanks - dave...more >>

Hello, Last Thursday everything worked great. This morning I get this message from my .aspx pages: --- Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. Source Error: Line 40: Dim objAdapter as New SqlDataAdapter(strSql, objConnection...more >>

Hi; I'm creating this as a new question since my previous question was marked answered. I was just able to do the following: Scenario A: 1) Install sqldmo (using my installer) to D:\Program Files\... 2) Install Sql Server to C:\Program Files\... Scenario B: 1) Install Sql Server to D:\...more >>

Dear professional Can any one tell me about the interview questions of SQL SERVER DBA Thanks NOOR ...more >>

Hello Guys! I have a corrupted MDAC Installation on a Windows XP Sp2 Client. The Application we use responds with the message "provider not found" for a MS SQL 2000 Connection. Poorly i cannot just install MDAC again since the setup denies that under Win XP Sp2. Is there any way to reins...more >>

Hi! I am trying to set up forms-based authentication to enable visitors to register to gain access to my website. I am using the codes from the book ASP.NET Unleashed, but I'm afarid I have very little knowledge in this area. The book says that I have to upload certian stored procedures to...more >>

Boy's, I write why I need a example about pass an array how parameters to stored procedure. I need an example from a stored procedure and a c# code call. I'm from Argentina, I wait you understand me and your answer. Javier...more >>

Our Server is running MS SQL 2000 with SP3 Installed. We are having an intermittent problem where some off our SP are running REALLY slow. The curious thing about this problem is that while trying to troubleshoot the problem, we discovered that the execution speed of the SP varies depending on...more >>