Does SQL Server 2005 have something like setup.iss?

Is there a way to capture the steps in a manual installation of SQL Server 2005 into a file similar to setup.iss in 2000? If there is, it's not readily apparent.

I've modified a template.ini file and used it for a successful installation. It's just that it would be more convenient to replay a perfectly executed manual installation. It isn't always obvious which selections in a manual install correspond to specific keywords in template.ini.

No, sorry, this isn't available for SQL Server 2005

Does SQL Server (either 2005 or 2008) have some things similar to Oracle Real Application

Dear all,
Does Microsoft SQL Server (either 2005 or 2008) have some things similar to
Oracle Real Application Clusters ?
As my company's database system work load is getting heavier and heavier,
many colleagues ask me whether we can join a couple of machines as a one
logical machines for a SQL Server database.
However, I know Microsoft Clustering can only provide an Active/Passive mode
and only Oracle Real Application Cluster might fulfill what they want.
So, can you tell me will SQL Server 2005 or 2008 also has this Real
Application Clusters feature ?I believe you mean "load balancing" and SQL Server does not have a feature
like that.
SQL Server has Active\Passive and Active\Active cluster structures. Which
are not about load balancing exactly.
You may use the cluster structure named Active\Active or a better term "more
than one active node" in a meaning load balancing if you divide your
database into 2 pieces. Locate half of it on one of the nodes in the cluster
and locate the other one on the other node. Or you may want to perform OLTP
processes on the first node and replicate the database on the first node to
the second node and perform OLAP, reporting processes on the second node.
I'm not sure about SQL Server 2008.
--
Ekrem Önsoy
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:47008666$1@.127.0.0.1...
> Dear all,
> Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> to
> Oracle Real Application Clusters ?
> As my company's database system work load is getting heavier and heavier,
> many colleagues ask me whether we can join a couple of machines as a one
> logical machines for a SQL Server database.
> However, I know Microsoft Clustering can only provide an Active/Passive
> mode
> and only Oracle Real Application Cluster might fulfill what they want.
> So, can you tell me will SQL Server 2005 or 2008 also has this Real
> Application Clusters feature ?
>
>|||Thanks
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:B0D0F3D9-C4BC-44C5-A025-3437562E86B3@.microsoft.com...
> I believe you mean "load balancing" and SQL Server does not have a feature
> like that.
> SQL Server has Active\Passive and Active\Active cluster structures. Which
> are not about load balancing exactly.
> You may use the cluster structure named Active\Active or a better term
"more
> than one active node" in a meaning load balancing if you divide your
> database into 2 pieces. Locate half of it on one of the nodes in the
cluster
> and locate the other one on the other node. Or you may want to perform
OLTP
> processes on the first node and replicate the database on the first node
to
> the second node and perform OLAP, reporting processes on the second node.
> I'm not sure about SQL Server 2008.
> --
> Ekrem Önsoy
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:47008666$1@.127.0.0.1...
> > Dear all,
> >
> > Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> > to
> > Oracle Real Application Clusters ?
> >
> > As my company's database system work load is getting heavier and
heavier,
> > many colleagues ask me whether we can join a couple of machines as a one
> > logical machines for a SQL Server database.
> >
> > However, I know Microsoft Clustering can only provide an Active/Passive
> > mode
> > and only Oracle Real Application Cluster might fulfill what they want.
> >
> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
> > Application Clusters feature ?
> >
> >
> >
>|||> I'm not sure about SQL Server 2008.
SQL2008 doesn't have any native support that is similar to Oracle RAC or DB2
DPF.
Linchi
"Ekrem Ã?nsoy" wrote:
> I believe you mean "load balancing" and SQL Server does not have a feature
> like that.
> SQL Server has Active\Passive and Active\Active cluster structures. Which
> are not about load balancing exactly.
> You may use the cluster structure named Active\Active or a better term "more
> than one active node" in a meaning load balancing if you divide your
> database into 2 pieces. Locate half of it on one of the nodes in the cluster
> and locate the other one on the other node. Or you may want to perform OLTP
> processes on the first node and replicate the database on the first node to
> the second node and perform OLAP, reporting processes on the second node.
> I'm not sure about SQL Server 2008.
> --
> Ekrem nsoy
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:47008666$1@.127.0.0.1...
> > Dear all,
> >
> > Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> > to
> > Oracle Real Application Clusters ?
> >
> > As my company's database system work load is getting heavier and heavier,
> > many colleagues ask me whether we can join a couple of machines as a one
> > logical machines for a SQL Server database.
> >
> > However, I know Microsoft Clustering can only provide an Active/Passive
> > mode
> > and only Oracle Real Application Cluster might fulfill what they want.
> >
> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
> > Application Clusters feature ?
> >
> >
> >
>|||Thanks for the info mate.
--
Ekrem Ã?nsoy
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:1BA00B04-8543-4ED8-ADAE-741773F05BD6@.microsoft.com...
>> I'm not sure about SQL Server 2008.
> SQL2008 doesn't have any native support that is similar to Oracle RAC or
> DB2
> DPF.
> Linchi
> "Ekrem Ã?nsoy" wrote:
>> I believe you mean "load balancing" and SQL Server does not have a
>> feature
>> like that.
>> SQL Server has Active\Passive and Active\Active cluster structures. Which
>> are not about load balancing exactly.
>> You may use the cluster structure named Active\Active or a better term
>> "more
>> than one active node" in a meaning load balancing if you divide your
>> database into 2 pieces. Locate half of it on one of the nodes in the
>> cluster
>> and locate the other one on the other node. Or you may want to perform
>> OLTP
>> processes on the first node and replicate the database on the first node
>> to
>> the second node and perform OLAP, reporting processes on the second node.
>> I'm not sure about SQL Server 2008.
>> --
>> Ekrem nsoy
>>
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:47008666$1@.127.0.0.1...
>> > Dear all,
>> >
>> > Does Microsoft SQL Server (either 2005 or 2008) have some things
>> > similar
>> > to
>> > Oracle Real Application Clusters ?
>> >
>> > As my company's database system work load is getting heavier and
>> > heavier,
>> > many colleagues ask me whether we can join a couple of machines as a
>> > one
>> > logical machines for a SQL Server database.
>> >
>> > However, I know Microsoft Clustering can only provide an Active/Passive
>> > mode
>> > and only Oracle Real Application Cluster might fulfill what they want.
>> >
>> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
>> > Application Clusters feature ?
>> >
>> >
>> >

Does sp_OA_Create work with .Net?

Does anyone know if a .Net DLL will work similar to a VB6 DLL using
sp_OA_Create?
TIA
JeffP...It is not supported for extended stored procedures or sp_OA procedures to ca
ll .NET code in CLR;
hosted within SQL Server's address space..
See:
http://support.microsoft.com/defaul...kb;en-us;322884
Also, below is with permission from David Browne, explaining how you can hav
e SQL Server execute CLR
code executing in its own process:
"
Short answer: Don't do it.
Calling managed code inside a stored procedure is not supported.
http://support.microsoft.com/defaul...kb;en-us;322884
At least not directly. You need some sort of unmanaged proxy to communicate
with your component running in another process.
For instance, http, or, drum roll, a COM+ Server Application.
This will cause COM+ to load an unmanaged proxy object in the SqlServer
process and will load the CLR into a COM+ surrogate process (dllhost.exe).
Which somebody here mentioned last w, and I just got around to testing.
It's all perfectly transparent to you, but you have to set up the COM+
server application.
Remember this is something different from .net remoting. With .NET remoting
you have a _managed_ proxy object in the local process, and so you load the
CLR in the local process as well as the remote process.
Anyway here's what I did:
I created this VB class
comTest.vb listing:
Imports System.Runtime.InteropServices
<ClassInterface(ClassInterfaceType.AutoDual),
ProgId("comTest.comTestClass")> _
Public Class comTest
Public Function Hello() As String
Return "hello"
End Function
End Class
build comTest.dll and registered it with
regasm /codebase comTest.dll /tlb:comTest.tlb
(complains that I haven't strong-named my assembly, which you should do.)
created an empty COM+ server application, set to run under a local
administrator account, and dragged comTest.dll into its components folder.
created an unmanaged host (vbscript will do), and invoked the component
using IDispach just like SQLServer.
test.vbs listing
Set d = CreateObject("comTest.comTestClass")
MsgBox d.Hello
Then I used the .net command line debugger cordbg.exe's 'pro' command to
list the processes hosting the CLR. And procexp.exe from
www.sysinternals.com to verify that the CLR's dll's were not loaded in my
unmanaged process. My unmanaged host did not load the CLR, although it
loaded "comsvcs.dll", and the CLR was loaded by the dllhost.exe process.
Then in sql I ran
declare @.object int
declare @.msg varchar(50)
declare @.rc int
declare @.hr int
declare @.source varchar(1000)
declare @.description varchar(1000)
exec @.rc = sp_oacreate 'comTest.comTestClass', @.object output
if @.rc <> 0
begin
EXEC @.hr = sp_OAGetErrorInfo @.object, @.source OUT, @.description OUT
print 'create failed ' + @.description
return
end
exec @.rc = sp_oamethod @.object, 'Hello', @.msg output
if @.rc <> 0
begin
EXEC @.hr = sp_OAGetErrorInfo @.object, @.source OUT, @.description OUT
print 'method failed ' + @.description
return
end
print 'return: ' + @.msg
exec @.rc = sp_oadestroy @.object
if @.rc <> 0
begin
EXEC @.hr = sp_OAGetErrorInfo @.object, @.source OUT, @.description OUT
print 'destroy failed ' + @.description
return
end
Ran fine, and still only one CLR loaded into dllhost.exe's process. So
think we can safely conclude that COM+ server applications do not violate
the prohibition against running managed code in SQLServer's process and
provide a convenient mechanism for interoperating with managed code from
TSQL.
David
"
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:eXAIE000FHA.2932@.TK2MSFTNGP10.phx.gbl...
> Does anyone know if a .Net DLL will work similar to a VB6 DLL using
> sp_OA_Create?
> TIA
> JeffP...
>

Does LIKE operator have major performance issue with variables?

Hi all,
Below are two similar SQL statements that give the same results:
1. SELECT * FROM InvoiceDtl WHERE IvoNum LIKE ('Ivo-0510-00001')
2. DECLARE @.IvoNum AS NVARCHAR (20)
SET @.IvoNum = 'Ivo-0510-00001'
SELECT * FROM InvoiceDtl WHERE IvoNum LIKE (@.IvoNum)
InvoiceDtl is a big table with 2.3++ million rows. IvoNum is of type
NVARCHAR (20) and has a non-clustered index.
I run both statements seperately in Query Analyzer. Statement 1 takes 1-2
seconds. But statement 2 takes 3-4 minutes (and makes my harddisk run mad)!
Cld anyone pls kindly advise why that is happening? TQ.SQL Server processes batches of SQL statements in 3 steps:
1) Parsing: check for invalid code
2) Compilation: generate an execution plan, which tables/indexes to use, and
the order to access them in etc
3) Execution: execute the execution plan generated in step 2
Now for the first statement SQL knows the value of IvoNum it has to look for
as early as step 2, because it is a literal. The Query optimizer can look up
statistics on the indexes and estimate how often the value 'Ivo-0510-00001'
appears in the column IvoNum, and generate the fastest execution plan to be
executed by step 3.
For the second statement, SQL Server does NOT know the value of IvoNum it
has to look as early as step 2. @.IvoNum is a variable, at the assignment of
a value to this variable only happens during execution in step 3. If T-SQL
had constants, you could declare @.IvoNum as a constant, and the value would
be available in step 2, but T-SQL only has variables not constants. So the
Query Optimizer does not know in step 2 to as to what the value of @.IvoNum
will be during execution. So it uses an estimate for the number of rows that
might match, and IIRC, that estimate is 30%. Remember that the value of
@.IvoNum is unknown during step 2, so it might be 'Ivo-0510-00001' , 'Ivo%'
'%0510-00001' or even '%' in step 3. This estimate leads to a very different
execution plan, which in cases will include scanning all 2.3 million rows in
the table.
Jacco Schalkwijk
SQL Server MVP
"HardKhor" <HardKhor@.discussions.microsoft.com> wrote in message
news:43932C3C-D0D8-42EE-AE09-7388DBA8D6CE@.microsoft.com...
> Hi all,
> Below are two similar SQL statements that give the same results:
> 1. SELECT * FROM InvoiceDtl WHERE IvoNum LIKE ('Ivo-0510-00001')
> 2. DECLARE @.IvoNum AS NVARCHAR (20)
> SET @.IvoNum = 'Ivo-0510-00001'
> SELECT * FROM InvoiceDtl WHERE IvoNum LIKE (@.IvoNum)
> InvoiceDtl is a big table with 2.3++ million rows. IvoNum is of type
> NVARCHAR (20) and has a non-clustered index.
> I run both statements seperately in Query Analyzer. Statement 1 takes 1-2
> seconds. But statement 2 takes 3-4 minutes (and makes my harddisk run
> mad)!
> Cld anyone pls kindly advise why that is happening? TQ.|||HardKhor,
I got some questions for you here...
1) Why do you have nvarchar as datatype here? wouldnt varchar or char be
better?
2) Why 20 chars at most? If 'Ivo-0510-00001' is the longest, why not
char(14) ?
3) Why use LIKE if 'Ivo-0510-00001' is an exact match? i.e ... WHERE
Something='Ivo-0510-00001'
/Lasse
"HardKhor" <HardKhor@.discussions.microsoft.com> wrote in message
news:43932C3C-D0D8-42EE-AE09-7388DBA8D6CE@.microsoft.com...
> Hi all,
> Below are two similar SQL statements that give the same results:
> 1. SELECT * FROM InvoiceDtl WHERE IvoNum LIKE ('Ivo-0510-00001')
> 2. DECLARE @.IvoNum AS NVARCHAR (20)
> SET @.IvoNum = 'Ivo-0510-00001'
> SELECT * FROM InvoiceDtl WHERE IvoNum LIKE (@.IvoNum)
> InvoiceDtl is a big table with 2.3++ million rows. IvoNum is of type
> NVARCHAR (20) and has a non-clustered index.
> I run both statements seperately in Query Analyzer. Statement 1 takes 1-2
> seconds. But statement 2 takes 3-4 minutes (and makes my harddisk run
mad)!
> Cld anyone pls kindly advise why that is happening? TQ.

Does any one have similar problem with nvarchar column storing chinese characters?

I am running into some wired problem with nvarchar(4000). When I insert the
chinese characters, the text got cut off. The following two sections shows
what happen, the first chinese section is what is ended up in the database,
the second section (separate by "--") show the complete
parameter value before IDbCommand.ExecuateQuery() is called. It is less
than 4000 bytes. It seems a chunk of text got loss somewhere.
No sure what happen here. But it seems to be a serious problem. My full
text search certainlly wouldn't work if I can't get the data into the
column. Is this a bug in 2005 CTP or something I did wrong ? Thanks
--Xin Chen
?...?? - ? - ? - ?... ? - ?Q - ?... ?
- ? - ?... ? - ? ? > ? > ? ??
?:2005?03?23?03:56?:????
?
????
???
??1937?12?13?27???,??
??,?,??
"? ?...?? - ? - ? - ?... ? - ?Q - ?... ?
? - ? - ?... ? - ? ? > ? > ? ??\n
?:2005?03?23?03:56?:????
?\n???? \n \n??
? \n ??1937?12?13?27???,?
???,?,???,??
????,??30??
?,???,??,??,??,?
???1938?3?24?,????,?
??2?31? ??,?27?,?
??,?31??,??28?,?
?31?,??29?,?2??,?
??,?2???31?,???
?4?3?,????,?
???,??,???
6?,???7?,???
?,???????
?,???,?4.6?,?7500?
??,??1????
??,??? ?\n ??
??\n ?? ????
???\n??? ??
\n?? ??\n??3-26
? ??\n?? ??\n?
?? ??\n?:? ?<?
?> \n ? ??"?"??:? ?
? ? \n -- ?? ChinaRen - ? - ? - ?
? - ? - ? - ? - ? - ?? - About SOHU -
?\nCopyright 2005 Sohu.com Inc.All rights reserved."
how are you inserting these characters? OpenRowset?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Xin Chen" <xchen@.xtremework.com> wrote in message
news:ulgv5WANFHA.1176@.TK2MSFTNGP15.phx.gbl...
> I am running into some wired problem with nvarchar(4000). When I insert
the
> chinese characters, the text got cut off. The following two sections
shows
> what happen, the first chinese section is what is ended up in the
database,
> the second section (separate by "--") show the complete
> parameter value before IDbCommand.ExecuateQuery() is called. It is less
> than 4000 bytes. It seems a chunk of text got loss somewhere.
> No sure what happen here. But it seems to be a serious problem. My full
> text search certainlly wouldn't work if I can't get the data into the
> column. Is this a bug in 2005 CTP or something I did wrong ? Thanks
> --Xin Chen
> ?...?? - ? - ? - ?... ? - ?Q - ?... ?
> - ? - ?... ? - ? ? > ? > ? ??
> ?:2005?03?23?03:56?:????
> ?
> ????
> ???
> ??1937?12?13?27???,??
> ??,?,??
> ----
--
> --
> "? ?...?? - ? - ? - ?... ? - ?Q - ?... ?
> ? - ? - ?... ? - ? ? > ? > ? ??\n
> ?:2005?03?23?03:56?:????
> ?\n???? \n \n??
> ? \n ??1937?12?13?27???,?
> ???,?,???,??
> ????,??30??
> ?,???,??,??,??,?
> ???1938?3?24?,????,?
> ??2?31? ??,?27?,?
> ??,?31??,??28?,?
> ?31?,??29?,?2??,?
> ??,?2???31?,???
> ?4?3?,????,?
> ???,??,???
> 6?,???7?,???
> ?,???????
> ?,???,?4.6?,?7500?
> ??,??1????
> ??,??? ?\n ??
> ??\n ?? ????
> ???\n??? ??
> \n?? ??\n??3-26
> ? ??\n?? ??\n?
> ?? ??\n?:? ?<?
> ?> \n ? ??"?"??:? ?
> ? ? \n -- ?? ChinaRen - ? - ? - ?
> ? - ? - ? - ? - ? - ?? - About SOHU -
> ?\nCopyright 2005 Sohu.com Inc.All rights reserved."
>
|||no, I am using a store proc and call it via ADO.NET in my app
I store my text in the nvarchar(4000) as string, I am not using openrowset.
the stored proc use regular insert into (...) values (...)
--Xin Chen
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:exEotkANFHA.2468@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> how are you inserting these characters? OpenRowset?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Xin Chen" <xchen@.xtremework.com> wrote in message
> news:ulgv5WANFHA.1176@.TK2MSFTNGP15.phx.gbl...
> the
> shows
> database,
complete
> ----
> --
>

Documenting SQL 2005 packages

Hi all

I would like to select transforms in a package and paste them as jpeg or similar into word or powerpoint in order to allow me to create a separate set of documentation.

However, whenever I copy some transformations and jump to word, the copy buffer is empty.

Any suggestions?

Thanks

I am not sure you can do what you are after, but I am intrigued. What do you mean by copy a transform? What do you expect to see?

|||

I would like to be able to paste the 'graphical' representation of a set of SSIS objects into a word or ppt document as a jpeg or similar.

|||

Does print screen not work for you?

-Jamie

|||

Hi Jamie

The problem with print screen are:

* Firstly, the quality of the image is quite poor by the time it is dumped into word,

* But, more importantly, if all the objects don't fit on the screen at one time, then print screen wont capture them.

I could easily solve the 2nd problem by zooming out, but then I lose all detail and defeat the purpose.

A number of my data flows have 20+ objects in them and won't fit on a single A4 page.

I would like to paste an image of them onto an A3 page in word or ppt so that I can include them in the warehouse documentation.

|||

I had thought of grabbing the graphics and making them into some Visio Shapes, that would allow graphical documentation of packages, but they are not my images to do with as I wish! MS?

|||

I know it seems a little bit of a strange thing to want to do, but I am only building the warehouse and will (hopefully) take no part in the adminstration.

So, in order to provide our DBA with a fighting chance, I want to do my utmost to give as much help as possible as to the inner workings of the packages.