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

blacklabellover2003 (10/26/2012)

---

Hi all,

I have an orphaned .mdf + .ldf fileset on our production box, I know how to attach them.

But I also need to find out who the last user...

can the two servers see each other, like on the same network or anything like that?

you could set up replication for preocedures, but i'm not sure the master database can...

if you've created your own procedures, and then marked them as system procs, it's easy.

1.you still script them like always (sp_helptext procname, or script them in the GUI.

2.Create them in...

exec sp_fkeys TableName will list all the relations for a single table, if you want to use that as a basis for a script.