Permanently Turn Identity Off Using Sql

Sep 3, 2002

How, using SQL, do I turn off the identity property in the table? I need a script to run against a number of db to permanently remove the identity property from the tables without needing to use Enterprise Manager.

Thank you,
Jill

View 1 Replies


ADVERTISEMENT

How Do I Turn The Identity Value On And Off In SQL 6.5

Aug 4, 1999

Can anyone help me with this problem. I have old data that I need to insert into a new table. I need to keep the old identity values and then turn them on again for the new data.

I'd be very grateful for any help.

Thanks

A.

View 2 Replies View Related

Dynamic Turn On/off Pk's Identity Via T-sql....

Sep 23, 2003

I have around 1200 databases and some of them may be required to turn off one table pk's identity. And they might be turned on later with a different seed and incrment.
But I don't find in alter table t-sql to turn them off or on or change the seed/increment value.
I need to turn off/on via t-sql without drop/add the pk field.
thanks
David

View 2 Replies View Related

Turn Identity Off On Insert

Jun 3, 2005

Hi,

I'm nesting a bunch queries, the parent being a select, and the children being inserts. I'd like to retain the auto generated IDs from the original table, and insert them into the new tables (into identity fields). I believe that there is a command that I can use to temporarily turn identity auto numbering off for the current query - can anyone help me with this?

Cheers,

View 1 Replies View Related

Transaction Log Can Not Be Truncated Permanently

May 27, 2006

My SQL Server 2000 database log was full (2MB) and I am unable to add new column to a table. So that I follow this article to truncate my log file to 1MB. It works. But when I add a new column to a table after that. The log file went back to 2MB in size and I got the "the log file is full" error message again for the operation. BTW, my reovery mode was set to "Simple". I don't understand how the save table operation can recover my change on log size. What should I do to "permanently" truncate my log?
http://www.support.microsoft.com/?id=272318
I did this:
DBCC SHRINKFILE (myDB_Log, 1)
BACKUP LOG myDB WITH TRUNCATE_ONLY
DBCC SHRINKFILE (myDB_Log, 1)

View 1 Replies View Related

DB Engine :: Deleting A Log File Permanently?

Jul 6, 2015

In SQL 2012 I'm trying to delete a log file (both physically and logically). There are two log files and one of them is unnecessary. When I click 'remove' in SSMS it will delete the log file, but then when I go back under database properties it's still showing up even though the file has been physically removed from the OS. I'm wondering what steps I can take to get rid of the file permanently?

View 12 Replies View Related

Is DTS Support In 2005 Going Away Permanently At Some Point?

Mar 6, 2007

I hope this is the right forum to post my question in.
 
Does anyone know if or when Microsoft will discontinue support for 2000 DTS Legacy packages within SQL Server 2005? We€™re in the process of migrating from 2000 to 2005 and have a lot of packages to migrate to Integration Services. We€™re having problems migrating the packages because quite a few of them are complex and won€™t run after migrating to IS without a major rewrite. Right now it seems that those packages will run just fine under the Legacy folder on the 2005 instance with the data connections pointed to 2005 databases. We€™d just like to plan appropriately if we absolutely have to migrate those packages to IS at some point soon. We realize that we'll need to create new packages using IS, though.

So I€™d appreciate it if anyone has heard anything to please let me know. I apologize if this has been asked before, but I couldn€™t seem to find any posts on it.
 Thanks!

View 4 Replies View Related

DB Engine :: How To Use Particular Query In Buffer Cache Permanently

Aug 3, 2015

I've a spatial (GIS) Data which is used frequently insertion, updation.

5 lakh records insertion in daily basis. when I trying to generate reports last 3 days or one weak, it takes 20-30 minute.

very disappointing while playing with clients. how to boostup and perform fast.

I think as so once we set query plan in buffer permanently then i would be faster than ever.

View 4 Replies View Related

DECRYPTING A Column Permanently With Table UPDATE

Mar 17, 2008

In SQL 2005, I've created a test scenario in AdventureWorks where I:

1.) Create a database master key:

IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE symmetric_key_id = 101)
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<password>'

GO

2.) Create a certificate:

CREATE CERTIFICATE HRCert
WITH SUBJECT = 'Comments'
GO

3.) Create a symmetric key:

CREATE SYMMETRIC KEY CommentKey
WITH ALGORITHM = DES
ENCRYPTION BY CERTIFICATE HRCert
GO

4.) Add a test column to the HumanResources.JobCandidate table:

ALTER TABLE HumanResources.JobCandidate
ADD Comments varbinary(8000)
GO

5.) Open the symmetric key for use:

OPEN SYMMETRIC KEY CommentKey
DECRYPTION BY CERTIFICATE HRCert
GO

6.) Insert and Encrypt values ('Yes') to the newly created column:

UPDATE HumanResources.JobCandidate
SET Comments = EncryptByKey(Key_GUID('CommentKey'), 'Yes')
GO

-------


Great. Now all the textbooks say that, to view the column values in a decrypted state, you should:

SELECT CONVERT(varchar, DecryptByKey(Comments)) AS [Decrypted Comments], *
FROM HumanResources.JobCandidate


------

Great, I get it. But here's the rub. What is the best way to permanently decrypt the column and keep it in a cleartext state?

Running the following works, but keeps the column values in a varbinary (hexadecimal) state which is what we originally created:

UPDATE HumanResources.JobCandidate
SET Comments = DecryptByKey(Comments)
GO

But if I want to transform this varbinary(8000) column into a human-readable varchar column, the only thing I could come up with was a temp table solution:

UPDATE HumanResources.JobCandidate
SET Comments = DecryptByKey(Comments)
GO

DECLARE @temp varchar(1000)
SET @temp = (SELECT TOP 1 CommentsFROM Human Resources.JobCandidate)

CREATE TABLE #decrypt (Comment varchar(1000))
INSERT INTO #decrypt (Comments) VALUES (@temp)
GO

ALTER TABLE HumanResources.JobCandidate
ALTER COLUMN Comments varchar(1000)
GO

UPDATE HumanResources.JobCandidate
SET Comments = (SELECT Comments FROM #decrypt)
GO

DROP TABLE #decrypt
GO

--------

It works, but seems so inelegant to me.

Is there an easier way?

View 5 Replies View Related

How To Automatically Replicate Remote Database Which Is Not Permanently Online

Jul 23, 2005

Dear group,I have to replicate remote data to a SQL Server in the headquarter.The data are on a site which does not have permanent online-connectionto the headquarter.I have written a script which replicates the data and i want to set upa process / batch on the headquarter-machine which roughly does thefollowing1) Connect to the remote site2) start replication script (in fact a stored procedure)3) on success disconnect from the remote siteAll this has to run automatically e.g. during nighttime.Could someone please outline how i set up the connection and keep itup during my database-action and how to automatically disconnect aftersuccess of my replication script.I'd be jolly grateful.Thanks in advance and Greetings from ViennaUli

View 1 Replies View Related

Transact SQL :: Store Date Permanently In Stored Proc

Aug 24, 2015

I have stored procedure which runs on some period, what i want is when it first run i want to store that date permanently or till the next time it runs again, and then i need to take my data from that store proc , where hist_date between (date stored when it ran first time,example, 08/21/2015) and today date.(exampple, 08/24/2015)

Now next time when it runs , date stored should be updated in this case it should be (08/24/2015) .

How can i do this in stored proc, I tried to use temp table  but it didn't work .

View 13 Replies View Related

Integration Services :: Saving Connection Manager Password Permanently

May 13, 2015

User A creates the SSIS Package and provides the password for the connection manager for a task (for OLE DB source) with SQL authentication. 

When User B tries to run the SSIS package, the error is thrown as : The package may be damaged.

On typing the password again inside the connection manager, the execution occurs successfully. Is there any workaround to save the password permamanently for the connection manager rather than each user entering it in order to run the package ?

View 4 Replies View Related

Recovery :: How To Remove Permanently Automatically Generate JOBS In Job Event

Jul 21, 2015

last couple of months we're getting automatically generate jobs under sql server job event. causing occupy the resources.

in daily basis i've to remove mannualy. i've do disable the job no of times from properties, but it generates again.

how to remove it permanently. following are the job which generates automatically-

15559-cook.exe,
15564-dbdotas
15565-dbdotas2
15552-ftpbacks.exe
15554-install.exe
15555-kills.exe
15557-kugou2010
15558-macs.exe
15553-pdoors.exe
15561-regs.exe
15562-regsa.exe

View 9 Replies View Related

How Can I Send Row Data To A SQL Database Table Via VB 2008, And Permanently Save And Display The Result?

Mar 11, 2008

This is related to:
How can I make some graphics drawings stick while others disappear?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2905460&SiteID=1


Except that now I am trying to connect and update to an Microsoft SQL Server Database File (SqlClient) via VB 2008 Express; specifically a table called €œHexMap€? that contains some columns that I am ready to insert some row data into. Here is what my program should do:

As I hover over a hexagon map of the US a red flickering hexagon follows the location of my mouse cursor. If I click on a given hexagon, the program draws a permanent blue hexagon, and sends a new set of row data into my database. Such information as the name of the state, row, column, center x, and center y, etc. Here is a quick snapshot of this program in action:

http://farm4.static.flickr.com/3128/2325675990_4155edbdee_o.jpg
-sorry, I didn't capture the mouse cursor inside the red hexagon

I think I am missing something since I appear to be able to connect successfully to the database table. Unfortunately, I never see the changes in the database, when I try to Show Table Data (via Database Explorer). I am hoping someone will review my code snippet (below) and tell me what I am missing. What happens when I run this code is that it acts like it works just fine, except that I have no indication that any changes were actually affected.




Code Snippet
'======================================================================================
Dim CN As New SqlClient.SqlConnection()
Dim da As New SqlClient.SqlDataAdapter

'Consider using Me._adapter that is used already

CN.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Mapboard.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
CN.Open()

'Use the following code to verify that a connection to the database has achieved
If CN.State = ConnectionState.Open Then


MsgBox("Workstation " & CN.WorkstationId & "connected to database " & CN.Database & "on the " & CN.DataSource & " server")
End If

Try

Catch ex As Exception MsgBox("FAILED TO OPEN CONNECTION TO DATABASE DUE TO THE FOLLOWING ERROR" & vbCrLf & ex.Message)
End Try

'use the Connection object to execute statements
'against the database and then close the connection
da = New SqlClient.SqlDataAdapter("select * from HexMap order by Territory", CN)

If CN.State = ConnectionState.Open Then CN.Close()
'==========================================================================

Dim rows As Integer

rows = 0

Dim CMD As New SqlCommand("INSERT HexMap (Hexagon, HexRow, HexCol, HexX, HexY, Territory) VALUES(HexCounter, CaptureRow,CaptureCol,Hx,Hy,Territory_ComboBox1.Text)", CN)

CN.Open()

rows = CMD.ExecuteNonQuery

If rows = 1 Then
MsgBox("Table HexMap updated successfully")
Else
MsgBox("Failed to update the HexMap table")
End If


If CN.State = ConnectionState.Open Then CN.Close()
'==========================================================================



Thanks for reviewing my code.

Technozoide

View 1 Replies View Related

How Can I Turn A -100 Into 100

Apr 6, 2008

This may sound silly, but I'm calculating how much someone owes over time verses how much they have paid for that period. So if they owe more than they have paid the result is an under payment amount like -$100. Then I need to add the -$100 to the new payment due, let's say $100. So the total Due is $200. But if I add -100 to 100 that equals 0.
Any suggestions?
 

View 3 Replies View Related

DTS - How To Turn On NO LOG !!!

Aug 3, 2001

How do you turn LOGGING OFF for a DTS package????

DB2 is a simple "LOAD DATA REPLACE NO LOG"... (can SQL Server make it any more difficult to find this option to turn on/off??!!!)

frustrated!!!!!!!!!!!!!!!!
thanks-

View 1 Replies View Related

T-sql Turn Off A Cpu

Nov 7, 2006

Hello,In SQL Server 2005 Enterprise, I can change the CPU affinity viaManagement Studio. Is there a way that I can change these settings viat-sql?I wish to use all my cpu's at night when my data warehouse builds andthen durning the day reduce the number of cpus for SQL so that theapplication can get more time.TIARob

View 2 Replies View Related

How Do I Turn It Off?

Dec 27, 2006

Ever since installing SQL Server 2005 Express Edition the XP Task Manager shows €œsqlservr.exe€? running normally, as a €œNETWORK SERVICE€? consuming 26MB of memory. This is true even after a cold reboot. I€™d like to turn SQL off since I am not currently planning on using it. I tried detaching a couple of projects I had started, as part of tutorials, but that did not make a difference.

So how do I turn SQL Server 2005 Express Edition off without removing it from the system, which I do not want to do?

Thanks.

Thomas

View 3 Replies View Related

How To Turn Off A Transaction Log?

Mar 27, 2001

I am running sqlserver 2000 Enterprise edition on Windows NT 4.0 service pak 6.
When ever I run a long query, the transaction log seems to fill up. How do you turn this transaction log off? Please let me know ASAP.

Thanks,
Ranjan

View 3 Replies View Related

Turn Value Into Column

Feb 23, 2015

I have this table:

ProductionID ResourceID Time
------------ ---------- -----
WO001 200012 5
WO001 200011 1
WO002 200013 2
WO003 200012 3
WO003 200032 4

and I want it to look like

ProductionID 200011 200012 200013 200032
------------ ------ ------ ------ ------
WO001 1 5 NULL NULL
WO002 NULL NULL 2 NULL
WO003 NULL 3 NULL 4

I am looking for a smart solution without hardcoding the column names (e.g. CASE WHEN ResourceID = '200012' THEN Time END as ['200012'], etc...), as there can be up to 15 different resources involved; usually they aren't but I want to keep the result as slim as possible without tons of columns containing nulls.

View 8 Replies View Related

Turn Off SQL Truncate?

Jul 10, 2007

I have a nvarchar(256) column and when I am using C# code to add data to it. When I enter data over 256 characters long, it automatically truncates. When I try to do this is the Query Editor, it will not allow me to and terminates with the error "Binary data or string would be truncated"

Is there a way to turn this automatic truncating off?

View 4 Replies View Related

Turn Validation Off

Aug 1, 2007

I have one data flow task which creating a database table (tempTable) and other task will migrate data from other database into this table. Now I add third task which will read the data from this tempTable. If tempTable is not in the database, then validation will failed. Is there a way to turn off validation at runtime.
In my case, my package running every night. I would like to delete this tempTable at end of package run. Now I have to pre create this temp table, and run package and leave the temptable around for the next run to pass validation problem.


Thanks!

Jun Fan

View 3 Replies View Related

Turn The List ?

Jan 13, 2007

How do I return a list of sold CD's, showing the last once (least sold) first? Below sql, ordered by DESC, returns a CD-list from 1, 2, 3 ... 49, 50, 51. (but I would like the turn it like this)

Least sold cd

51 Martin
50 Elvis
49 Krall


SELECT top 10 SUM(Cd.Price) AS Sales, Artist.Name
FROM Cd INNER JOIN
purchase ON Cd.Cd_id = purchase.Cd_id INNER JOIN
Cd_artist ON Cd.Cd_id = Cd_artist.Cd_id INNER JOIN
Artist ON Cd_artist.Artist_id = Artist.Artist_id
GROUP BY Artist.Name
ORDER BY SUM(Cd.price) DESC(Due to "=RowNumber(Nothing)" numbers are return instead of salesfigures.)

View 1 Replies View Related

Very Basic Question - No Where Else To Turn

Jul 5, 2001

I apologize in advance for bugging you all with a basic question, but I can't get it answered anywhere else.

I've been planning on learning MS SQL for a while and recently obtained SQL 2000 software. However, before I got the software I got several books on SQL 7. My question is this, are the differences between SQL 2000 and SQL 7 so great that I wouldn't be able to use the SQL 7 books with the v2000 software?

Thanks in advance,
Matt

View 1 Replies View Related

Turn $10 Into 10,000 In Just 14 Days With Paypal!!

Jul 27, 2004

$$ Make Money Business Opportunity $$

" I WAS SHOCKED WHEN I SAW HOW MUCH MONEY
CAME FLOODING INTO MY PAYPAL ACCOUNT."
Dear Friend,

This is a new program as you will see. It can be for
the U.S. or the U.K. This is a fantastic opportunity,
try it for yourself!! EVERYTHING DONE ONLINE ! !
With just £5 or $10 and a Paypal PREMIER or BUSINESS
account, you could make $$Thousands$$ in 2 SIMPLE
STEPS ! !

READ THIS VERY CAREFULLY THEN READ IT AGAIN. THIS IS
FAST, THIS IS NOT THE ONE YOU WILL BE WAITING TO WORK.

GUARANTEED - you will have $10,000 in two weeks.
Only $10, a Paypal PREMIER or BUSINESS account and 30
min are all that is needed to get this going.

GIFTING MADE EASY, PLEASE READ ON TO FIND OUT HOW

If you want to make a few thousand dollars real quick,
then please take a moment to read and understand the
MLM program I'm sharing with you. NO IT'S NOT what you
think. YOU DON'T have to send $10 to five or six
people
to buy a report, receipt or get on
their mailing list. Nor will you need to invest more
money later to get things
going. THIS IS THE FASTEST, EASIEST PROGRAM EVER, you
will be able to complete it in LESS THAN 30 MINUTES
and you will never forget the day you first viewed
this online.

If you're already running a home business, you can
easily do this one along
with it. If not, this is the FASTEST and EASIEST way
to earn serious money
online that you've ever seen so far in the history of
the Internet! This
program works no matter what country you are in, or
what currency you use.
It doesn't matter how old or how young you are. And
you certainly won't need
any special knowledge or talent. You won't need to run
a website, or make
phone calls, or make photocopies, or send out letters
through the mail, or
pay for advertising, etc. The only things you will
need are:

* An email address
* A Premier or Business PayPal account with at least
$10 deposited in it
* 30 minutes of your time

ONLY 2 SIMPLE AND EASY STEPS ! !

If you are doing other programs, by all means stay
with them. The more the
merrier, BUT PLEASE READ ON!! First of all, there are
only TWO POSITIONS, not
four, five or six like many other programs. This
program is more realistic and
much, MUCH FASTER. Because it is so easy, the response
rate for this program is
VERY HIGH and VERY FAST, and you will receive your
reward in FOURTEEN
DAYS. That's only TWO WEEKS - not one or two months.
Just in time for next months BILLS.

TRUE STORY --> Grace Kelly tells how she ran this
gifting summation four times last year. The first
time, she received $6,000 in cash in two weeks and
then $14,000 in cash the next three times.

When this program is continued, as it should be,
EVERYONE PROFITS!! DON'T BE AFRAID to send gifts to
strangers. It will come back to you ten folds. A
person can give you up to $10,000 per year and you
don't have to report it to the IRS.

THIS CAN AND WILL WORK FOR YOU! HERE ARE THE DETAILS:

Post this letter in 50 message boards, chat rooms, or
newsgroup. You don't need to post 200 like other
programs or email 100 people just to get started. Even
if you are already in a program like the send twenty
dollars to six people. CONTINUE IT and stay with it,
THOSE DO PAY OUT, but do yourself a favor, DO THIS ONE
TODAY as well, RIGHT NOW!!! It is simple and takes a
very small investment, only $10 and a Paypal PREMIER
or
BUSINESS account. iT WORKS AND IS DONE IN 2 SIMPLE AND
EASY STEPS ! ! This program WILL PAY FASTER before the
other programs you are working on even trickle in!!
Just give one person $10. THAT'S IT!! Follow the
simple
instructions and in
two weeks, you should have $10,000 because most PEOPLE
WILL RESPOND due to the LOW ONE TIME INVESTMENT, SPEED
AND HIGH PROFIT POTENTIAL.PLUS, since its done all
ONLINE, there is no time wasted mailing out letters
and the such ! ! We are not even figuring a 50%
response! So let's all keep it going and help each
other in these tough times. We all owe money to bill
collectors, and creditors. But, with this, if people
take the time to help each other, the good fortune
will follow. SO, Take the measly minutes this SIMPLE
and REWARDING program offers and give the gift that
gives back TODAY ! !.

Simply send a $10 gift to the person at POSITION #1,
if
your birthday is BETWEEN JAN 1 THRU JUNE 30, OR, if
your birthday is BETWEEN JULY 1 THRU DEC 31, send the
gift to the person at POSITION # 2.

HERE'S WHAT YOU NEED TO DO. . .

STEP 1

Ok, if you're not already a PayPal user, the very
first thing you need to do
is use the PayPal link below and SIGN UP. It takes
just two minutes!

Here's the URL:

https://www.paypal.com/us/mrb/pal=AQH5ZY3CXRHZN

Be sure to use this link so you can sign up for a free
PREMIER or BUSINESS
account. You'll need to have a PREMIER or BUSINESS
account (and not a
PERSONAL account) otherwise you won't be able to
receive credit card
payments from other people.

STEP 2

It is an undeniable law of the universe that we must
first give in order to
receive. So the first thing to do when you have your
Premier/Business PayPal
account is to IMMEDIATELY send a $10 payment from your
PayPal account to the email address in the position (1
or 2 - depending on your birthday in the timeline),
along with a note saying: "HERE IS A $10 GIFT FOR
YOU."
Be certain to add this note, as this is what KEEPS
THIS PROGRAM LEGAL. Instructions on how to send a
payment are under "SEND MONEY" at the Paypal Site.
It's so Easy!!

When you send your $10 payment to the first address in
the list, do it with a
great big smile on your face because "as you sow, so
shall you reap!"

After you have transferred a $10 payment to the email
address, something very eerie happens. It gives you an
indescribable, overwhelming sense of certainty, belief
and conviction in the system. You've just proved to
yourself that, because you have done it, there must be
a great number of other people ready to do exactly the
same. Thus you have now seen for yourself, first hand,
that this business actually works!

REMOVE the email address you are replacing (the one
you sent $10 to), and REPLACE it with your own email
address.

REMEMBER: Use the same EMAIL ADDRESS that is used with
YOUR Paypal account ! !

Paste your newly typed email address over the old one
and then post to 50 Message Boards, Chat Rooms, or
Newsgroups. DON'T MULL OVER IT, JUST 30 MIN OF YOUR
TIME, THAT'S IT THERE IS NO MORE TO DO!!

ACT FAST AND GET THE GIFT. HONESTLY AND INTEGRITY MAKE
THIS
PLAN WORK!! DO UNTO OTHERS AS YOU WOULD HAVE THEM DO
UNTO YOU .

POSITION#1 --- iexpoi@yahoo.com

POSITION#2 --- bumpsie@comcast.net
YOUR NAME COULD CYCLE FOR A LONG TIME ! ! THIS MAKES
IT THE GIFT THAT KEEPS ON GIVING.

This is excellent seed money to start or expand a
business, buy you dream home, car,
and pay off what ever bills you may have. Good luck
and God Bless. Play fairly, Good fortune will follow.

WHY THIS PROGRAM WORKS:

!! HONESTY AND INTEGRITY !!

Straight to the point, the reason this program is SO
SUCCESSFUL is beacuse when you follow these
instructions EXACTLY = GIVE A $10 GIFT and POST this
in
50 different message boards, there are only TWO
outcomes.

(1) A persons birthday will fall on the same half as
yours, therefore, YOU GET THE $10 . .

OR,

(2) a persons birthday will fall on the other half of
the timeline, therefore, YOU STAY IN YOUR POSITION and
get posted in 50 other MESSAGE BOARDS, etc . .

BOTTOMLINE: Either you get the $10 or your name gets
passed on for other people to give YOU $10 or pass
YOUR
name on to other people that will. It makes you think
though, the more you POST YOUR OWN POSTS, the BETTER
the results ! !

4 FACTORS THAT MAKE THIS PROGRAM SO SUCCESSFUL. . .

* EXTREMELY FAST RESPONSE

* EXTREMELY HIGH RESPONSE RATE

* UNLIMITED PROFIT POTENTIAL

* QUICK, SIMPLE AND CHEAP TO GET STARTED

So there it is. You now have the knowledge that will
enable you to make over
$10,000 within the next two weeks. The only thing that
can hold you back now
is a lack of faith or a lack of self-belief. However,
any doubts you may
currently have will disappear within a few days of
putting this plan into
practice. Trust me on this! You certainly won't regret
it.

SOME NOTES FROM PAYPAL WHICH YOU MAY FIND USEFUL

PayPal lets you pay anyone with an email address and
is the world's Number 1
online payment service. PayPal is accepted on over 3
million eBay auctions
as well as a countless number of online shops. You can
also use PayPal to
pay your friends - for example, it's a convenient way
to split the phone
bill with your room-mate, send cash to your kids in
college, or send cash to
someone in another country. Better yet, you can also
earn a referral bonus
of up to $100 each time someone signs up for a PayPal
account using your
referral URL!

When you send money through PayPal, you can fund your
payments with your
credit card or cheque account. You won't have to worry
about your privacy,
because PayPal keeps your accounting information safe
and secure. Making a
purchase with PayPal is far more secure than mailing a
cheque or giving your
credit card number to a stranger. That's why over 9
MILLION people from
around the world use PayPal to move money. Signing up
for a PayPal account
is free, easy, and it takes only a couple of minutes.

Thank you, and good luck in your ventures

Best Regards





P.S. Does this sound too good? Well maybe to some
skeptics it is. But it
actually works, and is worth the 30 minutes of your
time now. So, just make
a nice cup of tea and get started on it now. After
all, you can't lose, but
you stand to gain more in the next few weeks than many
people earn in a
year!

View 1 Replies View Related

How To Turn Off STATISTICS XML Option?

May 4, 2008

Hi,

How can I turn off STATISTICS XML option while executing a query in new query window of SQL server Management Studio?

View 1 Replies View Related

Turn Off Transaction Logs

May 21, 2008

I know I can't do this, but I hear of TRUNCATE LOG ON CHECKPOINT option. where do I find this to turn these off during large migration? thank you.

View 4 Replies View Related

Validate Subscriptions, Turn It Off

Feb 17, 2006

I added Validate Subscriptions to my publication using the procedure outlined in BOL. Procedure is listed below. I want to stop the validation for this publication. I do not want to validate any longer. How can I stop this process?
To validate transactional data using SQL Server Enterprise Manager

At the Distributor, expand Replication Monitor, expand Publishers, and then expand a specific Publisher.


Right-click a transactional publication, and then click Validate subscriptions.


Choose whether you want to validate all subscriptions or just specific subscriptions, and if you want to validate specific subscriptions, select those in the text box.


To choose the type of validation, click Validation Options.


Choose whether you want to compute a fast rowcount based on cached table information, compute an actual row count by querying the tables directly, or compute a fast row count and if differences are found, compute an actual row count.


You can also choose to enable Compare checksums to validate data, a binary checksum (if the Subscriber is running SQL Server 2000), and you can choose to stop the Distribution Agent after the validation has completed.

View 5 Replies View Related

Unable To Turn On SSB Queue

Jul 17, 2007

Hi all:



I've been stress-testing SSQ queue by pumping a lot of data to it. For the most part, the queue is cleared out fairly quickly using the activation stored procedure. However, for a second time now, I encountered a strange problem. For some reason, one message got stucked in the queue and would not dequeue. The status of the queue is turned OFF somehow. So I ran:



ALTER QUEUE [dbo].[TestQueue] WITH STATUS = ON;



to turn the queue status back on, but it would not turn ON. The last time I had this problem, I ended up dropping and recreating everything.



Has anyone experienced this strange behavior? Please help.



Thanks,



TDev

View 4 Replies View Related

Need To Turn Off The ROLLBACK Message

Feb 1, 2008

Hi All,

I have a trigger that in some cases will execute a rollback, when this happens, the following message is produced:


Msg 3609, Level 16, State 1, Line 1

The transaction ended in the trigger. The batch has been aborted.


I know that the rollback was successful but I need it to execute without generating this error message as it is causing problems for me.

Any help would be greatly appreciated.

Thanks.

Brett.

View 4 Replies View Related

How To Turn On Report Builder

Dec 11, 2007

Hi.
I setup a group on report service and give this group "Brower, My reports, report builder" permision, but I can't found report builder on client. does anybody can help?

Thanks

View 3 Replies View Related

Last GASP On Insert Row In Table With Identity Field, And Get New Identity Back ?

Jul 9, 2006

While I have learned a lot from this thread I am still basically confused about the issues involved.

.I wanted to INSERT a record in a parent table, get the Identity back and use it in a child table. Seems simple.

To my knowledge, mine would be the only process running that would update these tables. I was told that there is no guarantee, because the OLEDB provider could write the second destination row before the first, that the proper parent-child relationship would be generated as expected. It was recommended that I create my own variable in memory to hold the Identity value and use that in my SSIS package.

1. A simple example SSIS .dts example illustrating the approach of using a variable for identity would be helpful.

2. Suppose I actually had two processes updating these tables, running at the same time. Then it seems the "variable" method will also have its problems. Is there a final solution other than locking the tables involved prior to updating them or doing something crazy like using a GUID for the primary key!

3. We have done the type of parent-child inserts I originally described from t-sql for years without any apparent problems. (Maybe we were just lucky.) Is the entire issue simply a t-sql one or does SSIS add a layer of complexity beyond t-sql that needs to be addressed?



TIA,



Barkingdog

View 10 Replies View Related

Turn Off Transaction Log During Schema Change?

Nov 9, 2006

Is it possible to turn off transaction logging when making a table schema change? For example, when expanding a varchar field from 10 to 40 characters? This is occurring on a hosted site for a table with about 150,000 records. The db size is 200 Mb. If I try this normally with transaction logging enabled, I get the dreaded log file is full message, even if I first truncate it.
I was thinking about doing the following instead:

taking the db offline
creating a backup
disabling logging
change the schema
re-enable logging
put db back online
If a problem occurs during the schema change, I would just restore from the backup. Please let me know the following:

Is it possible to turn of the transaction logging for the schema change?
Do you see any problems with the above.
Alternatives?
One alternative is to look into increasing the db size. A second is to add a new field (named temp) to the table, copy the old field to the new field, delete the old field, add another field (with the original field name) with the new schema, copy the temp field to the new field, and finally delete the temp field. This should require less space in the transaction log. Unfortnately, it could possibly affect some linked Access databases with the new field order.
Thanks in advance.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved