By default SQL Server Express does not allow remote connections. Go into the SQL Server Configuration Manager and make sure you have either NamedPipes or TCP enabled in the...

Robin,

On the SQL Server open Reporting Services Configuration Manager and connect to the SQL Server you have reporting services installed on. If there are any red 'X's on the...

Have you seen this thread in the MSDN forums?

If you haven't processed any rows yet then all the rows will be returned.

Note the WHERE clause on the snippet. I load all the rows with a NULL ProcessedDate into the @emps table variable, process the rows. Then use the table...

Can't you set the data type from the flat file to a Date data type and then do a direct date comparison instead of a string comparison?

How about a sql agent job that runs after the refresh that checks for the value and sends an email using database mail if the value exists. Your...

Why would you need a cursor or use the PRINT statement to get this information?

Couldn't you just do this?

SELECT

ServerName,

Sum(FreeSpace_MB/1024) as [Disk...

What is the error?

How are you determining what db you are doing the last insert into?

Can you supply ALL the trigger code?

Most objects in SSRS have a visible property which has a toggle item property. You can default table 2's visible property to be hidden and set the toggle item...

Second that Barry.

PiMané (11/26/2009)

---

PS: Our app doesn't do batch updates... Just row by row, with id clearly identified. It sends multiples rows, with users table data type, but updates one by one...

Okay, Steve will be gone, now we can do whatever we...

Sweet Potato,...

I mean the physical process where a items is picked, put into a packet, and the packets are...