the security part that is tripping you up is this part:

@useself=N'True'

that means when you select from the linked server, your sql login is being used as the credentials for the...

ron morgan (7/21/2010)

---

my question is if i uninstall sql 2000 and then install sql 2008 or 2005 will it find and upgrade my pervious master and msdb left behind by...

after setting up that logging demo example, this query gets me the groups of login/logut elapsed times: note i am testing for a specific application name. i could then...

can you infer that ALL logins are only used for the ERP program?

a login does not know what database you are connecting to...the login happens before all that.

assuming you are...

you mean the first and last login per day?

once the data is in the table "Logging " fromt hat article, you can easily create a view that might do...

Martin one of the things you can do to get a better look at what SQL is doing behind the scenes is to look at either the Estimated Execution Plan...

Oracle_91 (7/21/2010)

---

Since we are restoring on a new server which is currently not in use and i have taken the sql server into single user mode then why cant we...

lak's suggestion still stands; if you bracket the server name you'd fix the issue:

select quotename(@@SERVERNAME)

--or

select quotename(ColumnName) from SomeTable

you are probably building the bcp string, right? very simple to get the...

that's the point...it's a business decision...some examples:

1. Data was entered in all capital letters(SMITH) biz rule says it should be proper cased.

2. duplicate data exists for the same...

yeah, there's no built in way to determine what data is "clean" or "dirty", it's a decision based on analysis...and one man's definition of dirty is not the same as...

I'm assuming the variable @VsebZapis is the string you are writing?

are you adding a CrLf to the end of it, so each record is on a single line in the...

it's in the registry, and there's one for each version of SSMS, it looks like:

for 2008, for exmaple it's here:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell

that's where you would change everything to default to...

i don't think your @r variable will ever be null.... count would return zero if nothing was found;

SELECT @r = COUNT(*) FROM SchoolStudents WHERE roll = @roll

--will return...

jyoti2705 (7/19/2010)

---

"embed it like in this example i created: so you'll need to get the IMAGE datatype to a file so it can be attached prior to the email", how...

AFAIK, images that will appear in an email must be an attachment. because html is interpreted, you can't just find and replace to ge tthe image in there.

your choices...