Create a publication in SQL Server 2005 Express

Hi,

is it possible to create a publication with SQL Server 2005 Express. I can′t seem to find it in Microsoft SQL Server Management Studio Express.

Do i have to install the full version? :(
Isn′t there any other option?

Thanks
SP

SQL Express can't serve as publisher or distributor for all types of replication. For more considerations for replication on SQL express. checkout this topic: http://msdn2.microsoft.com/en-us/library/ms165686.aspx in BOL.

You will need workgroup edition or above, although the workgroup has limitations on the number of subscriptions. For full detail, take a look at "Features Supported by the Editions of SQL Server 2005" (http://msdn2.microsoft.com/en-us/library/ms143761.aspx)

Peng

|||

No, it's not possible to create a publication in the Express edition. For express edition, your server can only use as subsriber in replication. You will need to use a regular SQL server as your publisher and distributor.

http://msdn2.microsoft.com/en-us/library/ms165616.aspx

Regards,

Gary

|||I′m installing the complete SQL Server 2005 and i have the following options:
sql server database services

CPU to slow for SQL Server 2005 express?

Hello,
i want to install the SQL 2005 express Server on a HP-Netserver LH4 with 1 Xeon 500 CPU. I know, that i must have a 600MHz CPU, but i cant change the CPU. Is there one way to start the SQL server?
Thanks
Michael

I *believe* that the processor discrepancy will just give you a warning, but still allow you to install/start the service. Is this the case?

Thanks,
Samuel Lester (MSFT)

|||No, the server will not bei installed, but the other parts of the program.

Michael
|||

Hi Michael,

Something else is going on. The processor check never issues a failure but only warnings. Based on what you described there shouldn't be an issue. The proc is an Intel Xeon (which is a P-III compatible or greater) so that shouldn't be a problem.

Can you explain what you mean by the engine won't be installed? Is it grayed out in the feature selection dialog? Does it attempt to install but fail?

Which version of Windows are you running?

coupla sql questions

say i have this file (below) and want to enter it into a table i've made. why cant i do this in query analyzer? and whats the easiest/best way to do it

insert into myTable

values(1,"StaticHtml","StaticHtmlPageControl"
2,"Questions","QuestionsPageControl"
3,"Login","LoginPageControl"
4,"SubmitSurvey","SubmitSurveyPageControl"
5,"Registration","RegistrationPageControl"
7,"SubmitUserAttributesSurvey","SubmitUserAttributesSurveyControl"
10,"RepeatPageGroup","RepeatPage"
11,"ThankYouPage","ThankYouPageControl")

also

whats the easiest way to make a copy of a database with and without the data - on the same server

cheers

Your SQL syntax isn't quite right. You'll need to write an INSERT INTO for each row you want to insert. i.e.

INSERT INTO myTable VALUES(1,"StaticHtml","StaticHtmlPageControl")

INSERT INTO myTable VALUES(2,"Questions","QuestionsPageControl")

You can script the database structure in order to create a blank instance of your database - Enterprise Manager / SQL Management Studio has options for this. To "copy" your database including data, you should take a backup.

|||

Thx man

bit annoying how u have to write insert into for each row, especially if there's heaps of rows.. i was hoping there might have been a better/easier way

i was also hoping you could copy a database like a table eg: select * into db1 from db2 - or something similar

anyway, i'll just keep hoping

cheers

|||

If you're selecting data from one table into another, you can do multiple rows - like this

INSERT INTO tblTable1
SELECT * FROM tblTable2

If the fields don't match, just specify the columns:

INSERT INTO tblTable1 (Field1, Field2, Field3)
SELECT FieldA, FieldB, FieldC FROM tblTable2

CountRows()

I've got a simple problem, but because this is my first report, I can't quite figure it out and it's driving me nuts!

I've got an ASP.NET web application with an .RDLC report. The report works fine, i.e. it renders data correctly. However, I cannot get the CountRows() function to work. I've got a cell in the group footer with the following:

=CountRows("grpBuyer")

And I'm getting the compiler error:

The value expression for the textbox XXXX has a scope parameter that is not valid...

"grpBuyer" is what is specified in the Grouping/Sorting property of the group header. I've also tried "TableRow2", which seems to be the name of the group header, but it yeilds the same compiler error.

Some please help!

Thanks, Alex

Hello Alex,

You have to pass group name (which by default is somewhat like "<objectname>_Group") to this function, you can get group name by right clicking on the object(table/matrix/list) and then click on "Group Tab" and there you will see all groups name for that object. You should pass exact name of Group, like i did =CountRows("list1_Details_Group") and it should work fine.

hope this will solve your problem.