Viewing 15 posts - 4,486 through 4,500 (of 13,469 total)
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....
October 29, 2012 at 8:35 am
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...
October 29, 2012 at 7:56 am
Lucasprss (10/29/2012)
What would be the easy way to find this within my thousands of records, would you say?
the issue is not with your data.
it's with the query you are using...
October 29, 2012 at 7:33 am
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 + ' '...
October 29, 2012 at 5:55 am
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...
October 26, 2012 at 3:07 pm
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?...
October 26, 2012 at 2:32 pm
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...
October 26, 2012 at 1:26 pm
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...
October 26, 2012 at 12:57 pm
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>'...
October 26, 2012 at 10:51 am
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...
October 26, 2012 at 9:36 am
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...
October 26, 2012 at 9:33 am
an example of what we need to try and help you:
--REQUIRED DDL
--DROP TABLE [dbo].[SAMPLETABLE]
CREATE TABLE [dbo].[SAMPLETABLE] (
[NO] ...
October 26, 2012 at 9:30 am
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...
October 26, 2012 at 9:04 am
jbulldog (10/26/2012)
October 26, 2012 at 7:30 am
Viewing 15 posts - 4,486 through 4,500 (of 13,469 total)