If you are unable to see the default instance from another machine, open up your SQL server configuration manager. Expand 'SQL Server Network Configuration' on the left. Right click on...

Since my post, I also discovered this method. Thanks for the follow-up though! Works great... object explorer details window has proven to be very helpful!

J-F Bergeron (1/15/2010)

---

I think this does what you need:

SELECT name ,

SCHEMA_NAME(Schema_ID) ,

Create_Date ,

...

Nevermind. Had a senior moment (which is weird since I am only 26). I just went with:

replace(replace(new_header,'#firstname#',firstname),'#lastname',lastname)

And added the replace statements for all of my string, and it seemed...

That was so simple that I just didnt even think about it. At any rate, it WORKED and you are my new favorite. You have been awarded all of the...

Better yet, I updated the DB with a new column. Each record has a column that has the full filepath and filename. How do I work with that?

I developed the windows application that successfully uploads the images into the DB. My issue is with all of the employees already in the database with no images. The thing...

So I figured out the issue. I only need 1 listbox, and it will repeat for each record. The problem is, it will only repeat from top to bottom. The...

I removed my logo completely, and I still get the same result. How else could get my desired outcome? I need to format a page of ID cards, and populate...

Maybe this will help you understand exactly where I am. This is a snapshot of the report in design mode, with some markup. Let me know if this helps.

Sorry for the misunderstanding. My images are using image controls. So moving past that, why does everything repeat 7 times.

If you could send what you have in C# maybe that would be a starting point for me. Thanks!

fixed the small syntax error on my insert, but still get the error near N' so my openrowset syntax is wrong.

USE [BFM]

GO

/****** Object: StoredProcedure [dbo].[add_employees] Script...

table =

USE [BFM]

GO

/****** Object: Table [dbo].[Employees] Script Date: 04/14/2009 17:20:46 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Employees](

[first_name] [varchar](50) NULL,

[last_name] [varchar](50) NULL,

[birthday] [datetime] NULL,

[blood_type]...

I threw together a really (REALLY REALLY DO NOT LAUGH I MEAN REALLY) crude cursor... I am having problems applying the OPENROWSET function syntactically. Here is what I have.

USE [BFM]

GO

/******...