You could use either

where ICCID_No = 'SIM#18 digit'

which assumes an exact match or you could use this

where ICCID_No LIKE 'SIM#18 digit%'

that version assume that there are multiple variations after...

Did you add the local admin accounts to the server in the wizard? If not, then you won't be able to get in even if you're god on your...

So what problems are you experiencing?

Are you also running out of space on the HD?.. or just in the DB file with error messages cropping up when trying to change some data?

If you can't do that or find out in google, then you are still a student.

Look up executenonquery in VS2008's help.

Is there any way to have a placeholder for the generated date?

-- Author:<Author,,Rémi Grégoire>

-- Create date: <Create Date,,GetDate()>

-- Description:<Procedure_Name, sysname, ProcedureName>

I want the getDate() to be replaced by '2010-01-15' when...

Select * from sys.objects WHERE type_desc = 'SQL_STORED_PROCEDURE' ORDER BY create_date

Hey gift... do you know of a way to export reports in SSRS straight to PDF in a loop so that I do it for all 2000 clients in the...

based on the very detialed question you just gave us :

Because! :w00t:

Why can you only deploy to test servers? If those reports are required for the business then they deserve to be on a prod server, period.

I didn't check out...

The services should be in administration tools / services under "SQL Server (SQL EXPRESS)" or something like that.

Make sure it's set to automatic start and that it is started.

You can...

Easy trick for dynamic sql question... always do a print before trying to execute and make sure that the printed version does what you want it to do. Save...

Why exactly do you think you need to do this?

Don't always believe Microsoft :-).

Try this and I'm pretty sure it'll work :

Create a linked server from SQL Server to the Access DB.

Then build a SP for the source...

Please show us sample output, I have a guess at that you want but I'm not sure.