Viewing 15 posts - 76 through 90 (of 96 total)
Sankyverma, the request is to get the last record not the max value record for each user.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
July 20, 2010 at 1:38 pm
We have used linked server. We also create separate logins, provide necessary access and execute linked server using the above login.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
July 20, 2010 at 1:32 pm
I was trying something to make this work. I did open Surface Area Configuration to check the remote connections.
When i click the "Remote Connections" i am getting the error message...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
July 16, 2010 at 10:44 am
Yes. and Both are set to run with "Local System" account. But still the same issue.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
July 15, 2010 at 4:11 pm
Yes. Thanks Paul.
I would like the automated script to run 24/7 and hope it would not block the memory if it going to keep it in cache.
How to program such...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
June 11, 2010 at 2:37 pm
The trace file got created successfully but it showing only "0" bytes. I am assuming the process has access since it has created the trace file in the network share...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
May 27, 2010 at 10:44 am
Hi,
I developed similar to one below.... but it not writing anything.. please let me know what is wrong in here?
--------------------
/****************************************************/
/* Created by: SQL Server Profiler ...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
May 27, 2010 at 10:33 am
But.. still i can select debuglocal and set the destination server to my test server and the report will get still deployed. Isn't it?
How debuglocal, debug tied up with...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
April 10, 2010 at 2:04 pm
Forgot to mention in the previous post.
The total records which would get updated would be around 10 million records.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
April 9, 2010 at 12:59 pm
This is the modified update statement based on your feedback...
UPDATE a
SET a.field1 = CASE WHEN b.field1 IS NOT NULL
THEN b.field1
ELSE a.field1
...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
April 9, 2010 at 12:55 pm
Thanks.
Eventhough table1 is very large, table2 would have less number of records around 3000 rows so i hope batch update is not required.
Also i am planning to add "date" condition...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
April 9, 2010 at 10:42 am
Hi,
I am trying to create notification in server A and want the read the queue data using stored procedure from server B. Can you help me with sample article of...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
December 24, 2009 at 10:19 am
For sql server deployment you might have to manually edit the manifest before deploying.
You may also try installing the BIDS helper (.net addin) through which you can deploy single package.
...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
April 6, 2008 at 10:33 pm
Do you want to do file based deployment or sql-server?
In the first case I would copy the package directly into the destination folder, login thru SSMS and to intergration services...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
April 5, 2008 at 11:01 pm
Making delay validation to true is just delaying the validation till runtime. This property would be useful when designing/building packages through BIDS.
What happens in a typical scenerio is when a package is...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
August 30, 2007 at 12:13 pm
Viewing 15 posts - 76 through 90 (of 96 total)