lots of things wrong here, let me point out a few, and then a script on how to create a linked server.

1. you cannot create objects in the sys. schema

2....

i played with something similar, where i was converting from xml/html entities to the unicode? character char definition.

the problem was i was using a recursive function, and the #of recursion...

the issue is not with your data.

it's with the query you are using...

the error is in the query you are creating, which you did not post.

it looks like you are concatenating a number to a string . like CustomerID + ' '...

nothing like getting it straight from the source, and testing it yourself.

BooksOnline has a page about what each of the server roles allows:

http://msdn.microsoft.com/en-us/library/ms175892(v=sql.90).aspx

play with this sample code below; this...

integers,decimals, numerics and floats data types don't have preceding zeros, so no preceeding zero would be correct for those data types.

you said numeric, but are you SURE they are numerics?...

when you restore a database on a different server, the users in the database become Orphaned, because the SID inside the database is not the SID that exists for...

not sure if this helps yet, but i think the issue is a WINS issue when you cannot resolve by name;

For example if you enter SERVER04 instead of a FQDN...

well, if your data is split with semicolons or some known string,, then you could split it with the DelimitedSplit8K function.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

With tblDoc([FROM])

AS

(

SELECT 'John Doe1 <John.Doe1@abcd.com>' UNION ALL

SELECT 'John Doe2 <John.Doe2@abcd.com>'...

put the variable string in parenthesis:

exec (@sql)

the default trace keeps a short list of recent changes;

if not too much time has passed, you can find out who did any changes and when:

easiest way is directly...

just the raw MYSQL database file all by itself, no.

you need a mysql instance running so you can connect to the database.

you might need to install MYSQL and attach that...

an example of what we need to try and help you:

--REQUIRED DDL

--DROP TABLE [dbo].[SAMPLETABLE]

CREATE TABLE [dbo].[SAMPLETABLE] (

[NO] ...

depending on the results of this command, we might be able to tell you if you can do anything; whether it's a repair or a re-install/rebuild of master:

post teh entire...

jbulldog (10/26/2012)

---

When I INNER JOIN all my tables (6) I pull all the records for a specific region which already have the field data I am querying to see...