correct group for help on transaction log ??

I have a problem with a transaction log, which of the many sql groups would
you recommend I post to ?
--
Regards
Chris DangerfieldHi,
You can post the details in this News group.
Thanks
Hari
"Chris Dangerfield" <chris@.dangerfieldbrothers.co.uk> wrote in message
news:pPsLc.88950$q8.51362@.fe1.news.blueyonder.co.uk...
> I have a problem with a transaction log, which of the many sql groups
would
> you recommend I post to ?
> --
> Regards
> Chris Dangerfield
>|||This one will do fine :-)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chris Dangerfield" <chris@.dangerfieldbrothers.co.uk> wrote in message
news:pPsLc.88950$q8.51362@.fe1.news.blueyonder.co.uk...
> I have a problem with a transaction log, which of the many sql groups
would
> you recommend I post to ?
> --
> Regards
> Chris Dangerfield
>

Copying Views from one db to other

Hi,
How to copy view from one db to other one...It should be
done via script...Is it possible to user SQL-DMO.
Regards
SridharYes, you can use SQL DMO t script objects. You can se DTS as well. Here is a
short examle of DMO:
Dim oSS As SQLDMO.SQLServer
Dim oDb As SQLDMO.Database
Dim oT As SQLDMO.Transfer
Dim sS As String
Sub Script()
Set oSS = New SQLDMO.SQLServer
Set oT = New SQLDMO.Transfer
oSS.LoginSecure = True
oSS.Connect
Set oDb = oSS.Databases("pubs")
oT.CopyAllTables = True
oDb.ScriptTransfer oT, SQLDMOXfrFile_SingleFile, "C:\pubs.sql"
End Sub
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<anonymous@.discussions.microsoft.com> wrote in message
news:8a2a01c485af$9b128630$a501280a@.phx.gbl...
> Hi,
> How to copy view from one db to other one...It should be
> done via script...Is it possible to user SQL-DMO.
>
> Regards
> Sridharsql

Copying data from Query Analyser.

When copying data from QA, is it possible to copy the headers with the data?
I tried Select All then Copy but got just the data.
Regards
Thief_did you hear "Thief_" <thief_@.hotmail.com> say in
news:ODKOU6jwFHA.2656@.TK2MSFTNGP09.phx.gbl:
> When copying data from QA, is it possible to copy the headers with the
> data? I tried Select All then Copy but got just the data.
> Regards
> Thief_
>
if we're talking about column headers with the data, if you are querying
using grid view that's the best you can get. If you switch to text view
or send the results to a file (CSV or text) you will get the column
headings.
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Hi ,
>From QA u will not be able to get the header name but if u tranfer ur
data to text file or excel file or access file u can get the table name
as well as the table structure.
HTH
from
Doller
Neil MacMurchy wrote:
> did you hear "Thief_" <thief_@.hotmail.com> say in
> news:ODKOU6jwFHA.2656@.TK2MSFTNGP09.phx.gbl:
> > When copying data from QA, is it possible to copy the headers with the
> > data? I tried Select All then Copy but got just the data.
> >
> > Regards
> >
> > Thief_
> >
> >
> if we're talking about column headers with the data, if you are querying
> using grid view that's the best you can get. If you switch to text view
> or send the results to a file (CSV or text) you will get the column
> headings.
> --
> Neil MacMurchy
> http://spaces.msn.com/members/neilmacmurchy
> http://spaces.msn.com/members/mctblogs|||doller wrote:
> Hi ,
>>From QA u will not be able to get the header name but if u tranfer ur
> data to text file or excel file or access file u can get the table name
> as well as the table structure.
> HTH
> from
> Doller
>
> Neil MacMurchy wrote:
>> did you hear "Thief_" <thief_@.hotmail.com> say in
>> news:ODKOU6jwFHA.2656@.TK2MSFTNGP09.phx.gbl:
>> When copying data from QA, is it possible to copy the headers with the
>> data? I tried Select All then Copy but got just the data.
>> Regards
>> Thief_
>>
>> if we're talking about column headers with the data, if you are querying
>> using grid view that's the best you can get. If you switch to text view
>> or send the results to a file (CSV or text) you will get the column
>> headings.
>> --
>> Neil MacMurchy
>> http://spaces.msn.com/members/neilmacmurchy
>> http://spaces.msn.com/members/mctblogs
>
If you use SQL Server Management Studio (Which is the "query analyzer"
that comes with SQL 2005), you can actually choose to include Column
Headers when you copy data from QA.
Regards
STeen|||did you hear "doller" <sufianarif@.gmail.com> say in
news:1127707753.325611.236790@.g43g2000cwa.googlegroups.com:
> Hi ,
>>From QA u will not be able to get the header name but if u tranfer ur
> data to text file or excel file or access file u can get the table name
> as well as the table structure.
> HTH
> from
> Doller
I think we need to clear up the term 'header'. Are we speaking of column
headings? if we are choose "results in text" from the query menu in QA.
this will allow the full columns to be selected for editing (copy/paste)or
a report saved to a file. You can also choose the "results to file" option
to save the output to a csv file. you made need to modify the options for
your results to get them in the format you would like, but these can be
chosen from tools --> option --> results (for more details check "Managing
SQL Query Analyzer Windows" from books online).
the other type of header might be in reference to a backup. perhaps this
was in reference to extend properties of a database (the
fn_listextendedproperties), but my guess is that this is what I have
mentioned above.
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||did you hear "Steen Persson (DK)" <spe@.REMOVEdatea.dk> say in news:
#HoIwUnwFHA.3740@.TK2MSFTNGP14.phx.gbl:
> If you use SQL Server Management Studio (Which is the "query analyzer"
> that comes with SQL 2005), you can actually choose to include Column
> Headers when you copy data from QA.
>
you can do that in 2000 as well. just don't do a "select *" ;)
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Neil MacMurchy wrote:
> did you hear "Steen Persson (DK)" <spe@.REMOVEdatea.dk> say in news:
> #HoIwUnwFHA.3740@.TK2MSFTNGP14.phx.gbl:
>> If you use SQL Server Management Studio (Which is the "query analyzer"
>> that comes with SQL 2005), you can actually choose to include Column
>> Headers when you copy data from QA.
> you can do that in 2000 as well. just don't do a "select *" ;)
>
Where can you specify that in Query Analyzer?
Regards
Steen|||did you hear "Steen Persson (DK)" <spe@.REMOVEdatea.dk> say in
news:urWES4zwFHA.904@.tk2msftngp13.phx.gbl:
> Where can you specify that in Query Analyzer?
select col1, col2, col3...
(it was a joke buddy...)
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs

Copy userdata

Hi,
how can I copy the userdata from one sqlserver to another sqlserver ?
Best regards
Axel LanserExactly what do you mean by "userdata"? Does the database exists? Does the tables exists? Do you
want to remove the rows in the destination tables if they exists? For all tables in a database? I
suggest you check out the DTS tool. This is probably the right tool for the job.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> Hi,
> how can I copy the userdata from one sqlserver to another sqlserver ?
> Best regards
> Axel Lanser|||You can use DTS if it's just the straight data that you care about and the
destination
server already has the schema defined. However, you may have to drop
any foreign keys on the destination server and then re-apply them after
the data has been loaded.
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> Hi,
> how can I copy the userdata from one sqlserver to another sqlserver ?
> Best regards
> Axel Lanser|||Hi,
with dts I can copy only tables and views from a database. In the sql server
I define much sql server specific und windows specific users with their right.
That users and their rights I had defined in one SQL-server. My problem is
now how can I copy them to a 2nd SQL-server.
Best refards
Axel Lanser
"Armando Prato" wrote:
> You can use DTS if it's just the straight data that you care about and the
> destination
> server already has the schema defined. However, you may have to drop
> any foreign keys on the destination server and then re-apply them after
> the data has been loaded.
> "ALN" <ALN@.discussions.microsoft.com> wrote in message
> news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> > Hi,
> > how can I copy the userdata from one sqlserver to another sqlserver ?
> >
> > Best regards
> >
> > Axel Lanser
>
>|||You don't have to build tables. You can choose to append to existing
tables.
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:02C317FA-CD0E-451C-87D7-89CDCD9CEB3F@.microsoft.com...
> Hi,
> with dts I can copy only tables and views from a database. In the sql
server
> I define much sql server specific und windows specific users with their
right.
> That users and their rights I had defined in one SQL-server. My problem is
> now how can I copy them to a 2nd SQL-server.
> Best refards
> Axel Lanser
> "Armando Prato" wrote:
> >
> > You can use DTS if it's just the straight data that you care about and
the
> > destination
> > server already has the schema defined. However, you may have to drop
> > any foreign keys on the destination server and then re-apply them after
> > the data has been loaded.
> >
> > "ALN" <ALN@.discussions.microsoft.com> wrote in message
> > news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> > > Hi,
> > > how can I copy the userdata from one sqlserver to another sqlserver ?
> > >
> > > Best regards
> > >
> > > Axel Lanser
> >
> >
> >|||Hi,
thank you very much. Today I found the right way to copy the userdata with
dts.
Best regards
Axel Lanser
"Armando Prato" wrote:
> You don't have to build tables. You can choose to append to existing
> tables.
> "ALN" <ALN@.discussions.microsoft.com> wrote in message
> news:02C317FA-CD0E-451C-87D7-89CDCD9CEB3F@.microsoft.com...
> > Hi,
> > with dts I can copy only tables and views from a database. In the sql
> server
> > I define much sql server specific und windows specific users with their
> right.
> > That users and their rights I had defined in one SQL-server. My problem is
> > now how can I copy them to a 2nd SQL-server.
> >
> > Best refards
> >
> > Axel Lanser
> >
> > "Armando Prato" wrote:
> >
> > >
> > > You can use DTS if it's just the straight data that you care about and
> the
> > > destination
> > > server already has the schema defined. However, you may have to drop
> > > any foreign keys on the destination server and then re-apply them after
> > > the data has been loaded.
> > >
> > > "ALN" <ALN@.discussions.microsoft.com> wrote in message
> > > news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> > > > Hi,
> > > > how can I copy the userdata from one sqlserver to another sqlserver ?
> > > >
> > > > Best regards
> > > >
> > > > Axel Lanser
> > >
> > >
> > >
>
>