Hello, I have a question I created a SP that by using dynamic sql access SP in all databases with certain name and get the output into a temp table...

Inna

11-20-2007 05:28 PM
Erland Sommarskog

SQL Server 2005 SP2 Can I combine Log Shipping and Clustering? That is, can I ship logs from the primary node in my cluster to an offsite warm...

aj

11-20-2007 12:58 PM
Greg D. Moore \(Strider\)

Hello, im having a problem integrating an SQL statement with my program, it works fine when theres a result but throws an error when there is no...

Ben

11-20-2007 10:24 AM
Ben

I am going to move to a different host. Can I get back up files of my SQL Server database (from the host) and use those to set up on the new host?...

JA

11-20-2007 03:43 AM
Nick Chan

No; you update the base table(s) that build the VIEW. The VIEW does not exist in the schema. Google the subject.

--CELKO--

11-18-2007 11:42 PM
Ed Murphy

can someone please advise me on the correct syntax to bcp export executing a stored procedures results to xml I know it begins bcp "exe...

Matthew Butler

11-18-2007 06:03 PM
Erland Sommarskog

Hello, I have 2 tables: Employees(EmployeeID, FirstName, LastName), EmployeeApplication(CreatedByID, EmployeeID,Date1, Date2, Content...) I need to...

Richard

11-17-2007 11:16 PM
Plamen Ratchev

Hi I have a Situation where im recieving data from a customer. this information is first Name last name date of birth accountNumber (not ours) but we...

Analizer1

11-17-2007 03:47 PM
Analizer1

Say for example, that I have a fairly complicated record of a thing meant for the US market. Then, a Canadian version is created based on the US one...

HumanJHawkins

11-17-2007 08:53 AM
--CELKO--

SQL Server allows for a user to have SELECT permission on a View without that user requiring an associated SELECT permission on the underlying...

Kevin Frey

11-16-2007 05:45 PM
Erland Sommarskog

Can a degenerate dimension act a a primary key in a fact table when a composite of the foreign keys (linking to dimensions) doesnt form a unique...

Jimbo

11-16-2007 03:23 PM
Jimbo

Hi All, We are using SQL2000 servers with transact replication to a warm stand-by server. We are seeing the following error from the Log...

Scott Bradley

11-16-2007 02:08 PM
Scott Bradley

Hi, i am using sql server 2000, and i make daily backups. I want to restore my backup to a test msde database i have. I don't know how i did it last...

Seguros Catatumbo

11-16-2007 10:13 AM
Seguros Catatumbo

Hi I've heard 2 things recently, can I confirm if their true/false? (1) If you have a stored procedure and you want to optimise it you can call exec...

codefragment@googlemail.com

11-15-2007 06:40 PM
Hugo Kornelis

I've got the following SQL SELECT count(*) FROM tablea A JOIN tableb B ON ..etc.. WHERE a.string_val = 'test' AND b.divider > 0 AND a.number > 0...

cobolman

11-15-2007 08:27 AM
Mark

(AP) Increasingly application developers are required to include flexible and extensible reporting options within their core product sets. This is...

YellowFin Announcements

11-15-2007 07:14 AM
YellowFin Announcements

hi everyone. i'm new to sql server. i have 2 tables. i want to return \all rows in both tables for each row in table2. please refer to the...

may_sapak1234@yahoo.com

11-15-2007 06:05 AM
newbie

On Wed, 14 Nov 2007 11:05:00 -0800, J?dru? <anowacki.pila (AT) interia (DOT) pl> wrote: Create an empty table. The table has two columns, one...

Roy Harvey (SQL Server MVP)

11-14-2007 05:42 PM
J dru

Dear comp.databases.ms-sqlserver, The XML 2007 Conference is almost here. XML 2007 is the world's largest and longest-running conference devoted to...

Stylus Studio

11-14-2007 02:40 PM
Stylus Studio

Hi, I'm running a SQL Server 2005 instance and a SQL Server 2000 instance and I'm looking to transfer data i've played with written in T-SQL (takes...

D0MZE

11-14-2007 12:21 PM
D0MZE

I need to create a test database on the live server for performance testing. From time to time, as structural modifications are made to the...

Neil

11-13-2007 07:26 PM
Neil

Hi, I am using SQL Server 2005 32 bit version. Could any one clarify me the caption database option with some examples? I am quite confused with the...

Om

11-13-2007 05:15 PM
Erland Sommarskog

I've recently bought a laptop with Windows XP Pro SP2. It keeps trying to install an MS update for SQL Server 2005 Express, but failing (with...

Tony

11-13-2007 11:11 AM
Mark D Powell

Hi, is there any method to call a store procedure into a function? Thanks Fabio

Fabio

11-13-2007 10:03 AM
Erland Sommarskog

I have a 64 bit SQL Server 2005 SP2 on a Windows 2003 x64. The developer said that he needed to use OLE to talk to Oracle so I went to Oracle and...

Mark D Powell

11-12-2007 01:32 PM
Mark D Powell

Hi What would be the quickest way to create a backup and revert program on an sql (2000) database? - Can you create a transaction on a database,...

codefragment@googlemail.com

11-10-2007 06:32 PM
Erland Sommarskog

Hello- I need help, badly! I'm trying to define parameters that within my first Reporting Services project. SELECT...

Jayphi

11-10-2007 02:39 AM
Ed Murphy

All, I have an Access DB. On a nightly basis, I want to look at an Other DB (not Access, but SQL) and: + Add any new records from Other.Clients...

Patrick A

11-09-2007 05:17 PM
Erland Sommarskog

SQL Server 2005 SP2 I read the excellent advice "Optimize tempdb in SQL Server by striping and splitting to multiple files"...

aj

11-09-2007 09:31 AM
Roy Harvey (SQL Server MVP)

I have a large table with an unique integer primary key and many coloums I have various programs to calculate many satistical information,...

Enorme Vigenti

11-09-2007 07:20 AM
Dan Guzman

Hello I am a newbie to this, so I would appreciate any help, I am struggling to get this to work CREATE PROCEDURE . @strfinalint as...

sunilkes@gmail.com

11-09-2007 06:49 AM
Erland Sommarskog

I have have 3 tables TableA, TableB and TableC. TableA holds the keys to TableB and TableC. I need a query which will display the details from TableB...

Nick

11-08-2007 04:58 PM
Hugo Kornelis

Hi, We are in the process of tuning the performance of our stored procs in SQL 2000 and are looking for a tool that would help us in comparing the...

Yash

11-08-2007 03:03 PM
steve

hello, i have this statment below which runs ok, but i need to add one more field to it.. I've tried lots of things, but i'm really struggling now so...

kevin@nu-urbanmusic.co.uk

11-08-2007 11:20 AM
jhofmeyr@googlemail.com

For New SQL & .NET Interview Questions May visit http://moredotnet.googlepages.com and http://www.dotnetuncle.com

dotnetuncle

11-08-2007 05:11 AM
dotnetuncle

A series of articles examining some basic concepts in Sql Server. Basic Anatomy of Sql Server, part I What is a stored...

steve

11-08-2007 03:31 AM
Ed Murphy

I have only been into SQL Server for a few months, and written several stored procedures. Is there a good software product available that...

Charlie

11-07-2007 07:25 PM
Oscar Santiesteban

Hi We're using SqlServer 2000. I want to run a DTS using the DTSRUN command. The commmand is inside a ".bat" file which my application is...

David Greenberg

11-07-2007 06:12 PM
Erland Sommarskog

Just curious if it's possible, and supported, to upgrade SQL 2005 from 32bit to 64bit. This is on top of Windows 2003 64bit. Trying to get the proper...

Jeremy Pavleck

11-07-2007 05:46 PM
Erland Sommarskog

I have three fields date, low, high. I need to calculate the midpoint of low and high and display...

amj1020

11-07-2007 05:27 PM
Hugo Kornelis

Ok, so I have had this problem more than once and can't think of a GOOD way to do it. Say I have a table with containing membership information...

sean.pinto@gmail.com

11-07-2007 12:41 PM
sean.pinto@gmail.com

Hi, We are in the process of tuning the performance of our stored procs in SQL 2000 and are looking for a tool that would help us in comparing the...

Yash

11-07-2007 09:08 AM
Thomas Kellerer

Hello, I have a table ItemID Version 12 1.0 12 1.1 12 2.0 13 2.0

sunilkes@gmail.com

11-07-2007 06:35 AM
sunilkes@gmail.com

Hi We still use SqlServer 2000 and DTSs. My question is: Can I pass a parameter to a DTS and if yes then how ? We would like to plan our screen...

David Greenberg

11-07-2007 01:43 AM
David Greenberg

Hi, I've just purchased a new machine with Windows Vista, and the cd I have for SQL Enterprise Manager (that works perfectly on Windows XP) no...

samhale@hotmail.com

11-06-2007 05:36 PM
Erland Sommarskog

I thought I saw this done once before. So today I hunted around in Books OnLine and did a Google search. So far I have found nothing close. So if ...

iano

11-06-2007 05:29 PM
Erland Sommarskog

Hi all, I have sql server 2005 express edition installed, i have to 2 registered instances sqlexpress1, sqlexpress2 within this server, i wanted the...

agnesroz@gmail.com

11-06-2007 05:25 PM
Erland Sommarskog

Hi, I'm trying to execute server-side trace with SqlServer 2000 on cluster. After scripting trace by Profiler I executed this script...

Bartolo

11-06-2007 10:26 AM
Bartolo

When I open QA on my development machine, I almost always go to the same db. Is it possible to create a shortcut for QA which tells it to go to that...

Neil

11-06-2007 07:14 AM
Jim McLeod

Hello, I have set the IDENTITY_INSERT on a table to ON. To test this, I tried to set it on another table and got the message that it was already on...

Matthew Wells

11-06-2007 02:57 AM
Erland Sommarskog