Showing posts with label script. Show all posts
Showing posts with label script. Show all posts

Friday, March 30, 2012

Need help ASAP with calendar datetime popup

I have a report created in ssrs. In the sql t script I used the between @.startdate and @.enddate statement for a parameter. In my report parameters dropdown I selected the timedate as my datatype. The report works fine if view it from my developement server the calander loads ok. When I view it from any other system the calender Icon is present but with not work. Any suggestions. Is there anything that needs to be put into the webconfig file to make this work. Javascript??

Hi,

Post your code. Someone will have a look at it.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

Wednesday, March 21, 2012

Need Clarification - merge replication

Hi,
I need to add new tables to merge replication.
These are the steps I have followed,
1. Executed the table script both in Publisher & Subscriber
2. Add 'rowguid' column in that table (Publisher & Subscriber)
3. In publication properties-->Articles, included the new table and
snapshot was automatically started.
(a) Is it the correct way to add tables to merge replication or is there any
better way?
(b) Should I stop the merge agent during this process?
Please advise.
Thanks,
Soura.
Soura,
unless you're doing a nosync initialization, it is normal to add the
articles to the publication, run the snapshot agent then the merge agent. A
full snapshot is created, but only the new article will get propagated.
There's no need to deal with the guid column - it'll get created for you if
a guid (rowguid) isn't there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Friday, March 9, 2012

Need advice for process of swapping DBs

I need to build a *.sql script that will remove a database (let's call
it "DB1") and replace it with a brand new empty database (let's call it
"DB2").

Caveat: I don't want to be left with database "DB1" having it's files
confusingly named "DB2.mdf" and "DB2_log.ldf". These two files should
also be renamed to "DB1.mdf" and "DB1_log.ldf" so that outside
customers are not left confused. In addition, I need to be able to
restore the original DB1 if anything goes wrong during, or even after,
the entire process.

Let's assume every customer's *.mdf's and *.ldf's will always reside in
C:\Program Files\Microsoft SQL Server\MSSQL\data folder.

I've researched sp_attach_db, but this looks more appropriate for
moving databases. This isn't what I want to do.

Thank you in advance.Simple.. In EM you can right right the database and "All tasks -
Generate SQL Script".. Go through and choose want you want to script
i.e. tables, views, stored procs, constraints, create database etc
etc.. Save the script as a .sql on your computer.. Open the file in a
text editor or SQL QA - modify the create database command and add a
"drop database" command at the top.