source control

RE: Geo-Bee

• by Eric-Iverson

• Redgate

• Reply

Nice story.  Keep up the good work.

2005-03-31

RE: replication between 2 SqlServers

• by robertk

• Redgate

• Reply

If you're in a workgroup instead of a domain... there's one possibility that I can think of.  The administrator account you're using is a local machine account, I'm assuming.  If you're using a local account, it really won't be able to talk to the other machine.I'm in a domain, and using an account with admin […]

2005-03-11

RE: SQL Server Developer Edition

• by PBirch

• SQLServerCentral.com

• Reply

No problem.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2005-02-24

RE: Read Only Tables

• by Paul-Sp

• SQLServerCentral.com

• Reply

HiMany thanks for your reply.  I'm sure the the View permissions would work fine.  However, I have a lot of tables and was hoping to find an easy way to do this.I was thinking about copying the database every few minutes using a DTS job.  This would provide a set of tables which wouldn't have […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2005-01-19

Question of the Day for 22 Feb 2005

• by Site Owners

• Redgate

• Topic

Comments posted to this topic are about the Question of the Day for 22 Feb 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=437.

2005-01-13

Cannot drop article ''TABLE60'' from publication ''DB_Comp'' ...

• by Mehrdad-Khorsandi

• SimpleTalk

• Topic

[ Merge Replication ] I work with a software that the act deletion and creation of the table and deletion and creation and change of the field by the users happens so much. for deletion of the table using this command : sp_dropmergearticle @publication='DB_Doc', @article = 'TABLE65', @force_invalidate_snapshot=1 , but after execute this command displayed […]

2005-01-08

2 reads

How to tell if MSDE or Full edition other than @@VERSION

• by James-Anderson

• SQLServerCentral.com

• Topic

HiI need a way to tell if an MSDE edition is installed or wheter it is a full edition, other than using @@VERSION ot SELECT SERVERPROPERTY ('edition')I need to be able to do it by looking at files installed, or file versions or registry entries.The reason I need to be able to do this is […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-12-17

2 reads

RE: get memory back

• by Alamir

• SimpleTalk

• Reply

if you have small memory on your computer (server), the best solution is to adjust SQL Server memory and make it FIXEDso in Enterprise manager do this: 1- right clcick on your server and choose (properties) 2- go to memory tab  3- check on (use a fixed memory size) and alocate it in trackbar under […]

2004-10-05

Use Excel Spreadsheet in Cursor

• by hansonjw

• SQLServerCentral.com

• Topic

Does anyone know how to use an Excel Spreadsheet as the from clause in a cursor? I'm trying to use data in an excel spreadsheet and perform function on the data row by row. The data will be be used to do updates and inserts in the database. I have to do this without using a linkserver […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-09-28

1 reads

Can I read the transaction log ?

• by Mariano-Pereiras

• Redgate

• Topic

Hi, I would appreciate any help on this questionIs there any way of reading the transaction log in SQL Server 7 to see what transactions where applied on a database, table, etc. ? If the answer is yes, is that a feature of MS-SQL or will I need a special software to do that ?(I've […]

2004-08-18

2 reads