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

James i'm guessing that you'd need to post the code for the procedure sp_sendmailsimmediately

clearly it's using CDO instead of the newer msdb.dbo.sp_send_dbmail, and a required parameter is missing.

take a look at this thread about logon triggers...

you could make a trigger like the example that refuses a connection if they are using the specific SUSER_NAME() of the account...

we have a handful of tables that require what you are asking;

what we did was add an additional column to the table, where the default value is the location/server/identifier for...

jvanderberg (7/15/2010)

---

You could install another database instance (possibly even express edition), and copy the databases using the same names. I can't imagine your website code likes different database names...

here's some code that will change every non-dbo schema-ed table to be in the dbo schema again. you'd need to tweak it to cover procs/views/functions, if that is an issue...

i think you'll have to script out all the functions,views and procedures to a file, then do a find and replace...

P1. -->[P2].

[P1] -->[P2]

then replace each CREATE PROCEDURE/CREATE FUNCTION/CREATE VIEW with...

Auto update stats only gets triggered when 20% of the rows in a table are modified...on small tables, that's fine, but on a big table, say a million rows,...