Is there a way around this? I have a SQL 2005 with 8 GB of memory that I want to set AWE on. But the local security policy won't let me, it...

Sanctus

11-30-2007 05:22 PM
Erland Sommarskog

I'm using SQL 2005 to export data. I would like to use the bcp utility to export data to an Excel file. I have to generate quite a few files and the...

Mike

11-30-2007 05:10 PM
Erland Sommarskog

Hi, Env is ms sql server 2000. ddl: create table srchPool(tid int primary key, taid int, s tynyint, uid tynyint); -- and sql server automatically...

Don Li

11-30-2007 05:06 PM
Erland Sommarskog

need the concpet of load balancing cluster ? can any one help me out with any link....?

Nit

11-30-2007 04:04 PM
Greg D. Moore \(Strider\)

As a junior SQL server DBA I am contemplating taking Microsoft certification for DBA's. Can someone advise what best route to take? Should i do SQL...

abu hisham

11-30-2007 09:50 AM
abu hisham

Hi, I am struggling with a simple query, but I just don't see it. I have the following example table. Table Messages ID Subject Reply_to 1 A ...

Sir Hystrix

11-30-2007 08:30 AM
Sir Hystrix

I am running this query to an sql server 2000 database from my asp code: "select * from MyTable where MySqlServerRemoveStressFunction(MyNtextColumn)...

verb13@hotmail.com

11-29-2007 06:28 PM
verb13@hotmail.com

Far below (in section "original 3 steps"), you see the following: 1. a temp table is created 2. some data is inserted into this table 3. some of the...

metaperl

11-29-2007 05:03 PM
Erland Sommarskog

Here's my issue. I'm tracking product interest so to speak. Each time a user clicks on a product the userid, product id, and date is tracked. Now...

rojelio@gmail.com

11-29-2007 03:20 PM
rojelio@gmail.com

Hi, I use SQL Server Enterprise Manager for MS SQL Express and i want to change the column properites for type of column, but I cann't change...

Mike

11-29-2007 03:17 AM
Erland Sommarskog

The version mssql 2005 sp1

lsllcm

11-28-2007 05:20 PM
Erland Sommarskog

I'm completely lost why a trival task in VFP is a lengthy drawn out process in SQL Server For Example A simple select statement where I want to...

bwalton_707@yahoo.com

11-28-2007 02:26 PM
--CELKO--

Hi, I have this problem. My software creates a temporary table (#MyTable). This table should be used by a report engine and printed each time...

D.

11-28-2007 09:30 AM
Madhivanan

Dear Gurus, I have table with following entries Table name = Customer Name Weight ------------ ----------- Sanjeev 85 Sanjeev 75

sanjeev.atvankar@gmail.com

11-28-2007 09:27 AM
Madhivanan

Hello We use MFG-PRO as our ERP system which in turn uses Progress databases. In the old version of SQL 2000, using DTS packages, we used to set the...

jags_32@yahoo.com

11-28-2007 09:12 AM
jags_32@yahoo.com

I think this question has been asked number of times. However, I am looking for some specific information. Perhaps some of you can help close the...

Manish

11-28-2007 08:52 AM
Erland Sommarskog

Hi, I was hoping somebody could assist me with this. I need to find accounts that do not contain a contact person called 'Accounting'. Each account...

Artie

11-28-2007 06:40 AM
jhofmeyr@googlemail.com

I work on a local copy of a database (Access 2000 MDB with ODBC linked tables to a SQL 7 database). The SQL Server db I'm working with is on my...

Neil

11-28-2007 05:46 AM
Neil

Hi I've got an Ingres database of some 200 tables which I need to import every night into SQL Server 2005 for use by Reporting Services. Most of the...

Chloe C

11-28-2007 05:28 AM
Chloe C

I have a Windows 2003 server with SQL Server 2005 installed. The server is on small drive and we would like to upgrade to much larger harddrives....

scoots987

11-28-2007 02:35 AM
Erland Sommarskog

Is there a way to check if INDENTITY is enabled on a table? I want to provide a table name and see if Identity (Autonumber) is enabled on it. Is...

CK

11-27-2007 05:44 PM
Erland Sommarskog

We have a pretty simple data flow that fetches data from our Source ERP system and dumps it into a SQL Server table. This functionality works, what...

jags_32@yahoo.com

11-27-2007 10:08 AM
jhofmeyr@googlemail.com

Hi, I have a DLL that I want to run from the Query Analyzer. I tried the following: USE master; EXEC sp_addextendedproc BLAH,...

Jim

11-27-2007 09:17 AM
jimshain@gmail.com

Dear Group First of all, my apologies for posting here. I tried the MS groups but they're so useless. As some of you work with ASP.NET and XML...

theintrepidfox

11-27-2007 08:28 AM
theintrepidfox

Hi there! Is there any way to find the user who did some transaction of update in query analyser in certain time ? The update was done manually in...

LaMoRt

11-26-2007 10:07 PM
LaMoRt

Hello, I have a very simple problem which I will illustrate with an example: I have the following records in my table: A 1 C A 2 C A 3 ...

Bart op de grote markt

11-26-2007 04:16 PM
Tony Rogerson

I have a SQL Server sitting in 1 network and a client sitting in another network We're troubleshooting an application and I've noticed something I...

Cliff

11-26-2007 02:34 PM
Cliff

I have a cursor looping through a list of tables that I want to truncate and then do a bulk insert into, Is this possible in SQL Server 2000 or do...

Boogha

11-26-2007 09:12 AM
Madhivanan

Hi Group, (I am just starting with SQL Server 2005.) On SQL Server 7 I used often the nice relation schema, where I used to draw out the whole...

Erwin Moller

11-26-2007 08:08 AM
Erwin Moller

Hi all, sorry if this is the wrong place to put this. I have two tables, both contain address info. I would like to update address1, address2, city,...

scoots987

11-26-2007 12:16 AM
scoots987

I am moving my site to a host that has SQL Server 2005. I am pretty good with Access, but I don't know much about SQL Server. I'm currently using...

JA

11-25-2007 11:06 PM
Plamen Ratchev

Hi, Env: MS SQL Server 2000 DB Info (sorry no DDL nor sample data): tblA has 147249 rows -- clustered index on pk (one key of datatype(int))...

Don Li

11-25-2007 09:21 PM
Don Li

I'm looking for articles about SQL Server for a new sql server community website. Any article dealing...

Patlv001

11-24-2007 11:21 AM
Patlv001

Hii everyone, I'm a web programmer, but I never understood sql injecting. All I found was that you can write "a' or 'a'='a" in the password field to...

ofiras

11-23-2007 09:24 PM
Ed Murphy

Hello! I have a table A with fields id,startdate and other fields. id and startdate are in the primary key. In the table B I want to introduce a...

Fritz Franz

11-23-2007 05:18 PM
Erland Sommarskog

hi I have a scenario where I have created a stored procedure wich task is to search in my database with certain criterias. For each record from this...

Winbug

11-23-2007 11:01 AM
Winbug

Hi, I'm new to SQL and databases in gnereal but am trying to source an application for windows that will sit on top of a small SQL database I have...

terry433iid@yahoo.com

11-23-2007 06:54 AM
Bart op de grote markt

Hi, i'm working on a project for convert from a mdb AccessXP(2002) application backend to SQL Server Express 2005. In the past i convertend a...

Yoda

11-23-2007 03:28 AM
Erland Sommarskog

The command below runs fine from within Management Studio exec sp_MSforeachtable @command1="exec sp_spaceused '?' " However, I'd like to run it via...

Desmodromic

11-22-2007 07:30 PM
Desmodromic

I have a CSV file that i need to import into a SQL table. The problem is the values in the first column are not brackited in "". There are over...

Frank

11-22-2007 05:46 PM
Erland Sommarskog

Hi, which is the syntax for a stored procedure that return to me the exact @@SPID of my current connection? I'm using ADO in VB6 and i want to...

Yoda

11-22-2007 05:45 PM
Erland Sommarskog

Hi, I am creating a attendance sheet software for inhouse use. my data is like...

Bhishm

11-22-2007 09:44 AM
Bhishm

Hi All Am new to sql server to sobear with me, have checked around but cant find an answer to this. I want to change fieldname from nvarchar(50) to...

andy@excommerce.net

11-22-2007 07:02 AM
jhofmeyr@googlemail.com

Howdy, hope someone can help me out with this. I want to run a job each night that copies files from one server to another. I cant even get a simple...

SJM

11-21-2007 05:11 PM
Erland Sommarskog

I am going to generate 32-bit encryption key with combination of any number of characters. what data type and its size should I use for that on MS...

TGEAR

11-21-2007 01:26 PM
Plamen Ratchev

Hi there, Is there any way to find the person or user who did update transaction manually in query analyser and not through application in certain...

LaMoRt

11-21-2007 05:46 AM
Madhivanan

Our client wants some changes/modifications in his DB but he does not want us to touch the original Server. What would be the best/ fastest solution...

Abu Hamza

11-21-2007 05:38 AM
Madhivanan

Here's the scoop, I got a generic-purpose database (in the form of *.mdb and *.ldf) from a 'reputable' source on the net. But when I attempted to...

time management

11-20-2007 11:17 PM
time management

I am having a problem with several reports at work. We use an SQL generator package where we fill in a template, and the system generates SQL...

AF

11-20-2007 05:53 PM
Erland Sommarskog

Hi, all. This might be a silly question... but I am very new to programming in SQL so please bear with me :) So. I'm using MS SQL Server 2005...

Allie

11-20-2007 05:40 PM
Erland Sommarskog