RSS Text Data Mining: dear

Showing posts with label dear. Show all posts

Wednesday, March 28, 2012

Running a stored procedure from an other

dear all
i need to execute a stored procedure in sql server from another stored
procedure.
this mean that my application calls a stored procedure but i need when i
call this stored proceure to run an other one.
is that possible and can anybody help me to acheive this task'
Thank you.GMK wrote:
> dear all
> i need to execute a stored procedure in sql server from another stored
> procedure.
> this mean that my application calls a stored procedure but i need
> when i call this stored proceure to run an other one.
> is that possible and can anybody help me to acheive this task'
> Thank you.
Sure it's possible. Just execute the other proc:
From Proc1
Exec dbo.Proc2 @.param1, @.param2
If you need a return value, then use:
Exec @.iRet = dbo.proc2 @.param1, @.param2
David Gugick
Imceda Software
www.imceda.com|||exec sp_name @.ParameterName = @.ParameterValue, ...

> dear all
> i need to execute a stored procedure in sql server from another stored
> procedure.
> this mean that my application calls a stored procedure but i need when
> i
> call this stored proceure to run an other one.
> is that possible and can anybody help me to acheive this task'
> Thank you.
>

Monday, March 26, 2012

Running a job continuously

Dear All,
I would like to have a job that runs all the times, how
should I set up the scheduler ?What does the job do? Do you have a loop so it never finishes? If not, they you cannot have it run
continuous, you can only schedule it very frequently.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Pidgeon" <anonymous@.discussions.microsoft.com> wrote in message
news:0bdc01c4a6fc$76513760$a301280a@.phx.gbl...
> Dear All,
> I would like to have a job that runs all the times, how
> should I set up the scheduler ?
>|||Thanks Tibor
We have a fairly complicated audit procedure where we need
to scan data continuously, I think I will go for your idea
of having a loop that never ends.
I know its a bit of a bad solution but I have been out
voted.
>--Original Message--
>What does the job do? Do you have a loop so it never
finishes? If not, they you cannot have it run
>continuous, you can only schedule it very frequently.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Pidgeon" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0bdc01c4a6fc$76513760$a301280a@.phx.gbl...
>> Dear All,
>> I would like to have a job that runs all the times, how
>> should I set up the scheduler ?
>>
>
>.
>|||What I do is creating 3 steps in the job. The 1st step runs "EXEC
msdb..sp_purge_jobhistory 'jobname'" to clear the history for this job. The
2nd step runs the procedure and it goes back to step1 on success and step 3
on failure. Step 3 prints out the error report in case the job fails.
"Pidgeon" wrote:
> Dear All,
> I would like to have a job that runs all the times, how
> should I set up the scheduler ?
>
>

Running a job continuously

Dear All,
I would like to have a job that runs all the times, how
should I set up the scheduler ?
What does the job do? Do you have a loop so it never finishes? If not, they you cannot have it run
continuous, you can only schedule it very frequently.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Pidgeon" <anonymous@.discussions.microsoft.com> wrote in message
news:0bdc01c4a6fc$76513760$a301280a@.phx.gbl...
> Dear All,
> I would like to have a job that runs all the times, how
> should I set up the scheduler ?
>
|||Thanks Tibor
We have a fairly complicated audit procedure where we need
to scan data continuously, I think I will go for your idea
of having a loop that never ends.
I know its a bit of a bad solution but I have been out
voted.

>--Original Message--
>What does the job do? Do you have a loop so it never
finishes? If not, they you cannot have it run
>continuous, you can only schedule it very frequently.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Pidgeon" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0bdc01c4a6fc$76513760$a301280a@.phx.gbl...
>
>.
>
|||What I do is creating 3 steps in the job. The 1st step runs "EXEC
msdb..sp_purge_jobhistory 'jobname'" to clear the history for this job. The
2nd step runs the procedure and it goes back to step1 on success and step 3
on failure. Step 3 prints out the error report in case the job fails.
"Pidgeon" wrote:

> Dear All,
> I would like to have a job that runs all the times, how
> should I set up the scheduler ?
>
>
sql

Wednesday, March 21, 2012

Run SQL Server 7.0 in Windows 2003

Dear all,
Lately, we bought a new server to replace existing old one. After
installation of SQL7, we followed to install the service pack 4 into it.
During the installation, we found SQL7 didn't support in 2003. And we
continued the process until it finished. Is there any problem on using SQL7
in windows server 2003? Since we have some application supported in SQL7
only, we have to keep using SQL7. Anyone know there's any impact using SQL7
in windows 2003? Please help
Best Rdgs
Ellis
Is there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So if
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> Lately, we bought a new server to replace existing old one. After
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using
SQL7
> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using
SQL7
> in windows 2003? Please help
> Best Rdgs
> Ellis
>
|||Do you have a test environment where you could test the application as a SS 2K installation but running in 7.0 compatibility mode? I'd try it with a full blown upgrade but, if you run into problems, try again in the old 7.0 compatibility.
Sincerely,
Anthony Thomas

"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message news:OeIJSk20EHA.1204@.TK2MSFTNGP10.phx.gbl...
Is there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So if
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...

> Dear all,
>
> Lately, we bought a new server to replace existing old one. After
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using

SQL7

> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using

SQL7

> in windows 2003? Please help
>
> Best Rdgs
> Ellis
>
>

Run SQL Server 7.0 in Windows 2003

Dear all,
Lately, we bought a new server to replace existing old one. After
installation of SQL7, we followed to install the service pack 4 into it.
During the installation, we found SQL7 didn't support in 2003. And we
continued the process until it finished. Is there any problem on using SQL7
in windows server 2003? Since we have some application supported in SQL7
only, we have to keep using SQL7. Anyone know there's any impact using SQL7
in windows 2003? Please help
Best Rdgs
EllisIs there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So if
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> Lately, we bought a new server to replace existing old one. After
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using
SQL7
> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using
SQL7
> in windows 2003? Please help
> Best Rdgs
> Ellis
>|||Do you have a test environment where you could test the application as a SS
2K installation but running in 7.0 compatibility mode? I'd try it with a fu
ll blown upgrade but, if you run into problems, try again in the old 7.0 com
patibility.
Sincerely,
Anthony Thomas
--
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message new
s:OeIJSk20EHA.1204@.TK2MSFTNGP10.phx.gbl...
Is there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So i
f
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Dear all,
>
> Lately, we bought a new server to replace existing old one. Afte
r
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using
SQL7
> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using
SQL7
> in windows 2003? Please help
>
> Best Rdgs
> Ellis
>
>

run sql script on sql server2000

dear all i am using ASP.net ,c# and SQL server 2000. i have create all
table, stored procedure .views in my application which is running well
in localhost but now i want to deploy it on server. for that pupose i
need to create all table, stored procedure, views on the domain server
database. can any one tell me how i can do it?Do you have the DDL in script files? Or do you just want to transfer the database on your local
database as is to the server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> table, stored procedure .views in my application which is running well
> in localhost but now i want to deploy it on server. for that pupose i
> need to create all table, stored procedure, views on the domain server
> database. can any one tell me how i can do it?
>|||Hi,
Easy option is :-
1. Backup the database in your machine [Use Backup Database]
2. Copy the backup file to Domain server
3. Restore the database [Use Restore Database command]
4. If you do not want the data then Truncate the contents of all tables.
follow the parent chld relationship
while truncating table.
Alternative is ... In the local sql server .. open enterprise manager..
Select database .. right click-- all tasks-- Generate SQL Scripts...
choose all objects , all dependant objects -- permissions...Script it as a
SQL file. Then you could use this script to create
objects in Domain sql server.
Thanks
Hari
SQL Server MVP
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> table, stored procedure .views in my application which is running well
> in localhost but now i want to deploy it on server. for that pupose i
> is
> need to create all table, stored procedure, views on the domain server
> database. can any one tell me how i can do it?
>|||but i am not having access of enterprise manager of domain server. i
need to run it only programatically.
Hari Prasad wrote:
> Hi,
> Easy option is :-
> 1. Backup the database in your machine [Use Backup Database]
> 2. Copy the backup file to Domain server
> 3. Restore the database [Use Restore Database command]
> 4. If you do not want the data then Truncate the contents of all tables.
> follow the parent chld relationship
> while truncating table.
> Alternative is ... In the local sql server .. open enterprise manager..
> Select database .. right click-- all tasks-- Generate SQL Scripts...
> choose all objects , all dependant objects -- permissions...Script it as a
> SQL file. Then you could use this script to create
> objects in Domain sql server.
>
> Thanks
> Hari
> SQL Server MVP
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >
> > table, stored procedure .views in my application which is running well
> > in localhost but now i want to deploy it on server. for that pupose i
> > is
> > need to create all table, stored procedure, views on the domain server
> >
> > database. can any one tell me how i can do it?
> >|||> but i am not having access of enterprise manager of domain server. i
> need to run it only programatically.
From what programming language?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> but i am not having access of enterprise manager of domain server. i
> need to run it only programatically.
> Hari Prasad wrote:
>> Hi,
>> Easy option is :-
>> 1. Backup the database in your machine [Use Backup Database]
>> 2. Copy the backup file to Domain server
>> 3. Restore the database [Use Restore Database command]
>> 4. If you do not want the data then Truncate the contents of all tables.
>> follow the parent chld relationship
>> while truncating table.
>> Alternative is ... In the local sql server .. open enterprise manager..
>> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> choose all objects , all dependant objects -- permissions...Script it as a
>> SQL file. Then you could use this script to create
>> objects in Domain sql server.
>>
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >
>> > table, stored procedure .views in my application which is running well
>> > in localhost but now i want to deploy it on server. for that pupose i
>> > is
>> > need to create all table, stored procedure, views on the domain server
>> >
>> > database. can any one tell me how i can do it?
>> >
>|||In asp.net using C#.net
Tibor Karaszi wrote:
> > but i am not having access of enterprise manager of domain server. i
> > need to run it only programatically.
> From what programming language?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> > but i am not having access of enterprise manager of domain server. i
> > need to run it only programatically.
> > Hari Prasad wrote:
> >> Hi,
> >>
> >> Easy option is :-
> >>
> >> 1. Backup the database in your machine [Use Backup Database]
> >> 2. Copy the backup file to Domain server
> >> 3. Restore the database [Use Restore Database command]
> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> follow the parent chld relationship
> >> while truncating table.
> >>
> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> SQL file. Then you could use this script to create
> >> objects in Domain sql server.
> >>
> >>
> >> Thanks
> >> Hari
> >> SQL Server MVP
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >
> >> > table, stored procedure .views in my application which is running well
> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> > is
> >> > need to create all table, stored procedure, views on the domain server
> >> >
> >> > database. can any one tell me how i can do it?
> >> >
> >|||Read the file from your code, take the SQL from the file you read and put it in a command object.
Whenever you reach GO in the script file, execute what you have in the command object using
ExecuteNonQuery.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> In asp.net using C#.net
> Tibor Karaszi wrote:
>> > but i am not having access of enterprise manager of domain server. i
>> > need to run it only programatically.
>> From what programming language?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> > but i am not having access of enterprise manager of domain server. i
>> > need to run it only programatically.
>> > Hari Prasad wrote:
>> >> Hi,
>> >>
>> >> Easy option is :-
>> >>
>> >> 1. Backup the database in your machine [Use Backup Database]
>> >> 2. Copy the backup file to Domain server
>> >> 3. Restore the database [Use Restore Database command]
>> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> follow the parent chld relationship
>> >> while truncating table.
>> >>
>> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> SQL file. Then you could use this script to create
>> >> objects in Domain sql server.
>> >>
>> >>
>> >> Thanks
>> >> Hari
>> >> SQL Server MVP
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >
>> >> > table, stored procedure .views in my application which is running well
>> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> > is
>> >> > need to create all table, stored procedure, views on the domain server
>> >> >
>> >> > database. can any one tell me how i can do it?
>> >> >
>> >
>|||ok fine it is working but how i can transfer data from local to domain
server.
--
Tibor Karaszi wrote:
> Read the file from your code, take the SQL from the file you read and put it in a command object.
> Whenever you reach GO in the script file, execute what you have in the command object using
> ExecuteNonQuery.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> > In asp.net using C#.net
> >
> > Tibor Karaszi wrote:
> >> > but i am not having access of enterprise manager of domain server. i
> >> > need to run it only programatically.
> >>
> >> From what programming language?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> > but i am not having access of enterprise manager of domain server. i
> >> > need to run it only programatically.
> >> > Hari Prasad wrote:
> >> >> Hi,
> >> >>
> >> >> Easy option is :-
> >> >>
> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> 2. Copy the backup file to Domain server
> >> >> 3. Restore the database [Use Restore Database command]
> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> follow the parent chld relationship
> >> >> while truncating table.
> >> >>
> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> SQL file. Then you could use this script to create
> >> >> objects in Domain sql server.
> >> >>
> >> >>
> >> >> Thanks
> >> >> Hari
> >> >> SQL Server MVP
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >
> >> >> > table, stored procedure .views in my application which is running well
> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> > is
> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >
> >> >> > database. can any one tell me how i can do it?
> >> >> >
> >> >
> >|||I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
Servers?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> ok fine it is working but how i can transfer data from local to domain
> server.
> --
> Tibor Karaszi wrote:
>> Read the file from your code, take the SQL from the file you read and put it in a command object.
>> Whenever you reach GO in the script file, execute what you have in the command object using
>> ExecuteNonQuery.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> > In asp.net using C#.net
>> >
>> > Tibor Karaszi wrote:
>> >> > but i am not having access of enterprise manager of domain server. i
>> >> > need to run it only programatically.
>> >>
>> >> From what programming language?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> > but i am not having access of enterprise manager of domain server. i
>> >> > need to run it only programatically.
>> >> > Hari Prasad wrote:
>> >> >> Hi,
>> >> >>
>> >> >> Easy option is :-
>> >> >>
>> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> 2. Copy the backup file to Domain server
>> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> follow the parent chld relationship
>> >> >> while truncating table.
>> >> >>
>> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> SQL file. Then you could use this script to create
>> >> >> objects in Domain sql server.
>> >> >>
>> >> >>
>> >> >> Thanks
>> >> >> Hari
>> >> >> SQL Server MVP
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >
>> >> >> > table, stored procedure .views in my application which is running well
>> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> > is
>> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >
>> >> >> > database. can any one tell me how i can do it?
>> >> >> >
>> >> >
>> >
>|||i am having data at my local sql server but i need to transfer it on
domain sql server. but i don't have direct access of domain enterprise
manager or query analyzer i am having only DSN Name uid and pwd.
Tibor Karaszi wrote:
> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
> Servers?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> > ok fine it is working but how i can transfer data from local to domain
> > server.
> >
> > --
> > Tibor Karaszi wrote:
> >> Read the file from your code, take the SQL from the file you read and put it in a command object.
> >> Whenever you reach GO in the script file, execute what you have in the command object using
> >> ExecuteNonQuery.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> > In asp.net using C#.net
> >> >
> >> > Tibor Karaszi wrote:
> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> > need to run it only programatically.
> >> >>
> >> >> From what programming language?
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> > need to run it only programatically.
> >> >> > Hari Prasad wrote:
> >> >> >> Hi,
> >> >> >>
> >> >> >> Easy option is :-
> >> >> >>
> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> follow the parent chld relationship
> >> >> >> while truncating table.
> >> >> >>
> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> SQL file. Then you could use this script to create
> >> >> >> objects in Domain sql server.
> >> >> >>
> >> >> >>
> >> >> >> Thanks
> >> >> >> Hari
> >> >> >> SQL Server MVP
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >
> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> > is
> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >
> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >
> >> >> >
> >> >
> >|||Let me see if I understand this.
You have a local SQL Server with schema and data. You have script files for the DDL on your local
SQL Server.
You now want to get both the schema and data to the other SQL Server.
I'm confused by the comment:
> but i don't have direct access of domain enterprise
> manager or query analyzer i am having only DSN Name uid and pwd.
If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
Anyhow, why not transfer the whole database using backup and restore? If you do want to script out
the data as well as the DDL, check out some options at:
http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>i am having data at my local sql server but i need to transfer it on
> domain sql server. but i don't have direct access of domain enterprise
> manager or query analyzer i am having only DSN Name uid and pwd.
>
> Tibor Karaszi wrote:
>> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
>> Servers?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> > ok fine it is working but how i can transfer data from local to domain
>> > server.
>> >
>> > --
>> > Tibor Karaszi wrote:
>> >> Read the file from your code, take the SQL from the file you read and put it in a command
>> >> object.
>> >> Whenever you reach GO in the script file, execute what you have in the command object using
>> >> ExecuteNonQuery.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> > In asp.net using C#.net
>> >> >
>> >> > Tibor Karaszi wrote:
>> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> > need to run it only programatically.
>> >> >>
>> >> >> From what programming language?
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> > need to run it only programatically.
>> >> >> > Hari Prasad wrote:
>> >> >> >> Hi,
>> >> >> >>
>> >> >> >> Easy option is :-
>> >> >> >>
>> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> follow the parent chld relationship
>> >> >> >> while truncating table.
>> >> >> >>
>> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> objects in Domain sql server.
>> >> >> >>
>> >> >> >>
>> >> >> >> Thanks
>> >> >> >> Hari
>> >> >> >> SQL Server MVP
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >
>> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> > is
>> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >
>> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>|||i want to say i don't have access of domain servers sql server
enterprise manager and query analyser which i have registered
Tibor Karaszi wrote:
> Let me see if I understand this.
> You have a local SQL Server with schema and data. You have script files for the DDL on your local
> SQL Server.
> You now want to get both the schema and data to the other SQL Server.
> I'm confused by the comment:
> > but i don't have direct access of domain enterprise
> > manager or query analyzer i am having only DSN Name uid and pwd.
> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
> Anyhow, why not transfer the whole database using backup and restore? If you do want to script out
> the data as well as the DDL, check out some options at:
> http://www.karaszi.com/SQLServer/info_generate_script.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
> >i am having data at my local sql server but i need to transfer it on
> > domain sql server. but i don't have direct access of domain enterprise
> > manager or query analyzer i am having only DSN Name uid and pwd.
> >
> >
> > Tibor Karaszi wrote:
> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
> >> Servers?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> >> > ok fine it is working but how i can transfer data from local to domain
> >> > server.
> >> >
> >> > --
> >> > Tibor Karaszi wrote:
> >> >> Read the file from your code, take the SQL from the file you read and put it in a command
> >> >> object.
> >> >> Whenever you reach GO in the script file, execute what you have in the command object using
> >> >> ExecuteNonQuery.
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> >> > In asp.net using C#.net
> >> >> >
> >> >> > Tibor Karaszi wrote:
> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> > need to run it only programatically.
> >> >> >>
> >> >> >> From what programming language?
> >> >> >>
> >> >> >> --
> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> http://www.solidqualitylearning.com/
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> > need to run it only programatically.
> >> >> >> > Hari Prasad wrote:
> >> >> >> >> Hi,
> >> >> >> >>
> >> >> >> >> Easy option is :-
> >> >> >> >>
> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> >> follow the parent chld relationship
> >> >> >> >> while truncating table.
> >> >> >> >>
> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> >> SQL file. Then you could use this script to create
> >> >> >> >> objects in Domain sql server.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> Thanks
> >> >> >> >> Hari
> >> >> >> >> SQL Server MVP
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >> >
> >> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> >> > is
> >> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >> >
> >> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >> >
> >> >> >> >
> >> >> >
> >> >
> >|||I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from your
Query Analyzer or Enterprise Manager but cannot login?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
>i want to say i don't have access of domain servers sql server
> enterprise manager and query analyser which i have registered
>
> Tibor Karaszi wrote:
>> Let me see if I understand this.
>> You have a local SQL Server with schema and data. You have script files for the DDL on your local
>> SQL Server.
>> You now want to get both the schema and data to the other SQL Server.
>> I'm confused by the comment:
>> > but i don't have direct access of domain enterprise
>> > manager or query analyzer i am having only DSN Name uid and pwd.
>> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
>> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
>> out
>> the data as well as the DDL, check out some options at:
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>> >i am having data at my local sql server but i need to transfer it on
>> > domain sql server. but i don't have direct access of domain enterprise
>> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >
>> >
>> > Tibor Karaszi wrote:
>> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
>> >> Servers?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> >> > ok fine it is working but how i can transfer data from local to domain
>> >> > server.
>> >> >
>> >> > --
>> >> > Tibor Karaszi wrote:
>> >> >> Read the file from your code, take the SQL from the file you read and put it in a command
>> >> >> object.
>> >> >> Whenever you reach GO in the script file, execute what you have in the command object using
>> >> >> ExecuteNonQuery.
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> >> > In asp.net using C#.net
>> >> >> >
>> >> >> > Tibor Karaszi wrote:
>> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> > need to run it only programatically.
>> >> >> >>
>> >> >> >> From what programming language?
>> >> >> >>
>> >> >> >> --
>> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> > need to run it only programatically.
>> >> >> >> > Hari Prasad wrote:
>> >> >> >> >> Hi,
>> >> >> >> >>
>> >> >> >> >> Easy option is :-
>> >> >> >> >>
>> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> >> follow the parent chld relationship
>> >> >> >> >> while truncating table.
>> >> >> >> >>
>> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> >> objects in Domain sql server.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> Thanks
>> >> >> >> >> Hari
>> >> >> >> >> SQL Server MVP
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >> >
>> >> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> >> > is
>> >> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >> >
>> >> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >> >
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>|||Just tell me can i login to my domain servers enterprise manager or
query analyser by using DSN name.
suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
then how i can access it by using enterprise manager or query analyser.
Tibor Karaszi wrote:
> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from your
> Query Analyzer or Enterprise Manager but cannot login?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
> >i want to say i don't have access of domain servers sql server
> > enterprise manager and query analyser which i have registered
> >
> >
> > Tibor Karaszi wrote:
> >> Let me see if I understand this.
> >>
> >> You have a local SQL Server with schema and data. You have script files for the DDL on your local
> >> SQL Server.
> >>
> >> You now want to get both the schema and data to the other SQL Server.
> >>
> >> I'm confused by the comment:
> >>
> >> > but i don't have direct access of domain enterprise
> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >>
> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
> >>
> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
> >> out
> >> the data as well as the DDL, check out some options at:
> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
> >> >i am having data at my local sql server but i need to transfer it on
> >> > domain sql server. but i don't have direct access of domain enterprise
> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >> >
> >> >
> >> > Tibor Karaszi wrote:
> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
> >> >> Servers?
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> >> >> > ok fine it is working but how i can transfer data from local to domain
> >> >> > server.
> >> >> >
> >> >> > --
> >> >> > Tibor Karaszi wrote:
> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a command
> >> >> >> object.
> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object using
> >> >> >> ExecuteNonQuery.
> >> >> >>
> >> >> >> --
> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> http://www.solidqualitylearning.com/
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> >> >> > In asp.net using C#.net
> >> >> >> >
> >> >> >> > Tibor Karaszi wrote:
> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> > need to run it only programatically.
> >> >> >> >>
> >> >> >> >> From what programming language?
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> >> http://www.solidqualitylearning.com/
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> > need to run it only programatically.
> >> >> >> >> > Hari Prasad wrote:
> >> >> >> >> >> Hi,
> >> >> >> >> >>
> >> >> >> >> >> Easy option is :-
> >> >> >> >> >>
> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> >> >> follow the parent chld relationship
> >> >> >> >> >> while truncating table.
> >> >> >> >> >>
> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> >> >> SQL file. Then you could use this script to create
> >> >> >> >> >> objects in Domain sql server.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> Thanks
> >> >> >> >> >> Hari
> >> >> >> >> >> SQL Server MVP
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >> >> >
> >> >> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> >> >> > is
> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >> >> >
> >> >> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >
> >> >> >
> >> >
> >|||I don't think that these tools accept DSN. You have to type in the server name (or, IP etc, as found
in your DSN), and select your login attributes (SQL Server login, login name and password).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160371392.636159.274620@.c28g2000cwb.googlegroups.com...
> Just tell me can i login to my domain servers enterprise manager or
> query analyser by using DSN name.
> suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
> then how i can access it by using enterprise manager or query analyser.
> Tibor Karaszi wrote:
>> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from
>> your
>> Query Analyzer or Enterprise Manager but cannot login?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
>> >i want to say i don't have access of domain servers sql server
>> > enterprise manager and query analyser which i have registered
>> >
>> >
>> > Tibor Karaszi wrote:
>> >> Let me see if I understand this.
>> >>
>> >> You have a local SQL Server with schema and data. You have script files for the DDL on your
>> >> local
>> >> SQL Server.
>> >>
>> >> You now want to get both the schema and data to the other SQL Server.
>> >>
>> >> I'm confused by the comment:
>> >>
>> >> > but i don't have direct access of domain enterprise
>> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >>
>> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager,
>> >> right?
>> >>
>> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
>> >> out
>> >> the data as well as the DDL, check out some options at:
>> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>> >> >i am having data at my local sql server but i need to transfer it on
>> >> > domain sql server. but i don't have direct access of domain enterprise
>> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >> >
>> >> >
>> >> > Tibor Karaszi wrote:
>> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two
>> >> >> SQL
>> >> >> Servers?
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> >> >> > ok fine it is working but how i can transfer data from local to domain
>> >> >> > server.
>> >> >> >
>> >> >> > --
>> >> >> > Tibor Karaszi wrote:
>> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a
>> >> >> >> command
>> >> >> >> object.
>> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object
>> >> >> >> using
>> >> >> >> ExecuteNonQuery.
>> >> >> >>
>> >> >> >> --
>> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> >> >> > In asp.net using C#.net
>> >> >> >> >
>> >> >> >> > Tibor Karaszi wrote:
>> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> > need to run it only programatically.
>> >> >> >> >>
>> >> >> >> >> From what programming language?
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> > need to run it only programatically.
>> >> >> >> >> > Hari Prasad wrote:
>> >> >> >> >> >> Hi,
>> >> >> >> >> >>
>> >> >> >> >> >> Easy option is :-
>> >> >> >> >> >>
>> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> >> >> follow the parent chld relationship
>> >> >> >> >> >> while truncating table.
>> >> >> >> >> >>
>> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> >> >> objects in Domain sql server.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> Thanks
>> >> >> >> >> >> Hari
>> >> >> >> >> >> SQL Server MVP
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >> >> >
>> >> >> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> >> >> > is
>> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >> >> >
>> >> >> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>|||but only DSN name , uid and pwd is given to me not server name and
database name in such condition how i can transfer my data.
Tibor Karaszi wrote:
> I don't think that these tools accept DSN. You have to type in the server name (or, IP etc, as found
> in your DSN), and select your login attributes (SQL Server login, login name and password).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160371392.636159.274620@.c28g2000cwb.googlegroups.com...
> > Just tell me can i login to my domain servers enterprise manager or
> > query analyser by using DSN name.
> > suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
> > then how i can access it by using enterprise manager or query analyser.
> >
> > Tibor Karaszi wrote:
> >> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from
> >> your
> >> Query Analyzer or Enterprise Manager but cannot login?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
> >> >i want to say i don't have access of domain servers sql server
> >> > enterprise manager and query analyser which i have registered
> >> >
> >> >
> >> > Tibor Karaszi wrote:
> >> >> Let me see if I understand this.
> >> >>
> >> >> You have a local SQL Server with schema and data. You have script files for the DDL on your
> >> >> local
> >> >> SQL Server.
> >> >>
> >> >> You now want to get both the schema and data to the other SQL Server.
> >> >>
> >> >> I'm confused by the comment:
> >> >>
> >> >> > but i don't have direct access of domain enterprise
> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >> >>
> >> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager,
> >> >> right?
> >> >>
> >> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
> >> >> out
> >> >> the data as well as the DDL, check out some options at:
> >> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
> >> >> >i am having data at my local sql server but i need to transfer it on
> >> >> > domain sql server. but i don't have direct access of domain enterprise
> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >> >> >
> >> >> >
> >> >> > Tibor Karaszi wrote:
> >> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two
> >> >> >> SQL
> >> >> >> Servers?
> >> >> >>
> >> >> >> --
> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> http://www.solidqualitylearning.com/
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> >> >> >> > ok fine it is working but how i can transfer data from local to domain
> >> >> >> > server.
> >> >> >> >
> >> >> >> > --
> >> >> >> > Tibor Karaszi wrote:
> >> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a
> >> >> >> >> command
> >> >> >> >> object.
> >> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object
> >> >> >> >> using
> >> >> >> >> ExecuteNonQuery.
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> >> http://www.solidqualitylearning.com/
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> >> >> >> > In asp.net using C#.net
> >> >> >> >> >
> >> >> >> >> > Tibor Karaszi wrote:
> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> >> > need to run it only programatically.
> >> >> >> >> >>
> >> >> >> >> >> From what programming language?
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> >> >> http://www.solidqualitylearning.com/
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> >> > need to run it only programatically.
> >> >> >> >> >> > Hari Prasad wrote:
> >> >> >> >> >> >> Hi,
> >> >> >> >> >> >>
> >> >> >> >> >> >> Easy option is :-
> >> >> >> >> >> >>
> >> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> >> >> >> follow the parent chld relationship
> >> >> >> >> >> >> while truncating table.
> >> >> >> >> >> >>
> >> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> >> >> >> SQL file. Then you could use this script to create
> >> >> >> >> >> >> objects in Domain sql server.
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >> Thanks
> >> >> >> >> >> >> Hari
> >> >> >> >> >> >> SQL Server MVP
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> >> >> >> > is
> >> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >
> >> >> >
> >> >
> >|||A DSN is something that you create locally on your machine. It contains the server name, possibly an
instance name (if not the default instance) and the database name. If they won't give you that
information, you should look for some other provider.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160408183.524642.222390@.m7g2000cwm.googlegroups.com...
> but only DSN name , uid and pwd is given to me not server name and
> database name in such condition how i can transfer my data.
> Tibor Karaszi wrote:
>> I don't think that these tools accept DSN. You have to type in the server name (or, IP etc, as
>> found
>> in your DSN), and select your login attributes (SQL Server login, login name and password).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160371392.636159.274620@.c28g2000cwb.googlegroups.com...
>> > Just tell me can i login to my domain servers enterprise manager or
>> > query analyser by using DSN name.
>> > suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
>> > then how i can access it by using enterprise manager or query analyser.
>> >
>> > Tibor Karaszi wrote:
>> >> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from
>> >> your
>> >> Query Analyzer or Enterprise Manager but cannot login?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
>> >> >i want to say i don't have access of domain servers sql server
>> >> > enterprise manager and query analyser which i have registered
>> >> >
>> >> >
>> >> > Tibor Karaszi wrote:
>> >> >> Let me see if I understand this.
>> >> >>
>> >> >> You have a local SQL Server with schema and data. You have script files for the DDL on your
>> >> >> local
>> >> >> SQL Server.
>> >> >>
>> >> >> You now want to get both the schema and data to the other SQL Server.
>> >> >>
>> >> >> I'm confused by the comment:
>> >> >>
>> >> >> > but i don't have direct access of domain enterprise
>> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >> >>
>> >> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager,
>> >> >> right?
>> >> >>
>> >> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to
>> >> >> script
>> >> >> out
>> >> >> the data as well as the DDL, check out some options at:
>> >> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>> >> >> >i am having data at my local sql server but i need to transfer it on
>> >> >> > domain sql server. but i don't have direct access of domain enterprise
>> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >> >> >
>> >> >> >
>> >> >> > Tibor Karaszi wrote:
>> >> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between
>> >> >> >> two
>> >> >> >> SQL
>> >> >> >> Servers?
>> >> >> >>
>> >> >> >> --
>> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> >> >> >> > ok fine it is working but how i can transfer data from local to domain
>> >> >> >> > server.
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> > Tibor Karaszi wrote:
>> >> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a
>> >> >> >> >> command
>> >> >> >> >> object.
>> >> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object
>> >> >> >> >> using
>> >> >> >> >> ExecuteNonQuery.
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> >> >> >> > In asp.net using C#.net
>> >> >> >> >> >
>> >> >> >> >> > Tibor Karaszi wrote:
>> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> >> > need to run it only programatically.
>> >> >> >> >> >>
>> >> >> >> >> >> From what programming language?
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> >> > need to run it only programatically.
>> >> >> >> >> >> > Hari Prasad wrote:
>> >> >> >> >> >> >> Hi,
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Easy option is :-
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> >> >> >> follow the parent chld relationship
>> >> >> >> >> >> >> while truncating table.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> >> >> >> objects in Domain sql server.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Thanks
>> >> >> >> >> >> >> Hari
>> >> >> >> >> >> >> SQL Server MVP
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> >> >> >> > is
>> >> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>

Wednesday, March 28, 2012

Running a stored procedure from an other

Monday, March 26, 2012

Running a job continuously

Running a job continuously

Wednesday, March 21, 2012

Run SQL Server 7.0 in Windows 2003

Run SQL Server 7.0 in Windows 2003

Run SQL Server 7.0 in Windows 2003

run sql script on sql server2000

run sql script on sql server2000

run sql script on sql server2000

RSS Text Data Mining

Blog Archive

About Me