"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...

i don't think the collation is going to affect you at all, you should use the default server collation, you just have to use nvarchar columns everywhere instead of varchar,...

the function below returns all possible colaltions on your server ...much more than i care to digest .

the second query is just the collations currently in use.

hope that helps:

select *...

Frances L (8/23/2011)

---

easy way to write this sp

I want to update one table field value according to other table value.

table a

ID Certfication

2 ACNS-BC

3 CCRN

if table a have...

Jnrstevej (8/23/2011)

---

Thanks for your reply Lowell and kvishu83

@Lowell its just a portion of the SP I've created. You are completely right with your advise it has solved the problem:-) i...

in some cases, that's absolutely true; after answering the same posting question over and over again, some folks get jaded;

I myself got snarky a while back and when someone posted...

just a day or so ago someone asked for the same thing;

see this topic for the discussion and a working solution:

http://www.sqlservercentral.com/Forums/FindPost1162705.aspx

shouldn't your function return a datetime instead of a char(8)?

anyway, you just wrap it with the function you wrote:

here's two ways, depending on if you change the function to return...