I'd consider loading the datatable you want to search agaisnt ONCE, and then using a filter( if you are using a BindingSource) like bindingSource.Filter("SomeValue LIKE '" & sometextbox.text & "%'")

or...

In SQL Server Managment Studio, if you do Help>>About, what version do you see?

here's mine for 2008:

Microsoft SQL Server Management Studio 10.0.4000.0

Microsoft Analysis Services Client Tools ...

existing PDF's are just plain not editable, especially not from TSQL;

you'll need to generate a new PDF instead.

it's also possible to append two PDF's together, so PDF2 starts where PDF1...

i think this is because the client tools you are using are from SQL 2005, and not 2008;(that 9.0.0 stuff means 2005 to me)

can you try to do the same...

maybe the stored procedure is in the master or msdb database, and thus was not migrated when that one database moved over?

well, a function can only create a table variable, and...

"not working properly" is really tough to diagnose without seeing the function itself,as well as how you are calling the function.

do you mean it doesn't return the expected results? wrong...

i believe the key is the anticipated WHERE statement;

take this as an example:

SELECT

contactId,

FirstName,

LastName,

Email

From Contacts

Where Entitytblkey =77

the index's columns should match...

could it be something simple like this?

EVERY command changes the @@ROWCOUNT.

you need to capture the value immeditely after the updates or deletes, and compare the saved value right?

also, i don't...

skrilla99 (8/23/2011)

---

You could also run systeminfo remotely from your local command line:

c:\>systeminfo /S serverName | find "System Model:"

Which could be readily put together in a batch for all servers.

I don't...

Ninja's_RGR'us (8/23/2011)

---

+1 on the people not using google or bols. I've seen cases where the guy just didn't know what term to type in and it's a pleasure...

you could do this:

ALTER DATABASE DBNAME SET RESTRICTED_USER

I think that will prevent any other connections from hitting the database unless they are a sysadmin...you don't have everyone logging inas...

you'll need to set up database mail, which is very simple to do, and you'll need a known SMTP server with a usnername and password, most likely.

the actual command is...

if you don't keep your datetimes in datetime columns, you run into wierdnesses like this.

here's one way to sort varchar representations of time the way you asked: ideally, you'd simply...