Viewing 15 posts - 76 through 90 (of 1,478 total)
It means that replication between Oracle and SQL Server will be deprecated. Replication between instances of SQL Server will not be deprecated.
Adi
August 5, 2015 at 4:02 am
I don't have any exprience but this is take from BOL (https://msdn.microsoft.com/en-us/library/ms151149.aspx) "Heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using...
August 5, 2015 at 3:37 am
Not very pretty, but it will work as long as you don't have any apostrophes in your string. There is a good chance that other inputs should also be...
August 5, 2015 at 3:29 am
In your message you wrote that you are creating a new login but in the error message it seems that you are trying to add a user as a member...
July 22, 2015 at 4:09 am
If you can't have duplicate records, then here is another way:
declare @tt table
( TagId int, TagType int, ReportId int)
INSERT...
July 15, 2015 at 2:00 am
You can also improve backup time by specifying in the backup statement the number of buffercount and maxtransfersize. Have a look at this article –
May 20, 2015 at 5:06 am
Delete doesn't cause page splits, so you don't have to worry about the delete statements regarding page splits. Inserts might cause page split. It depends on the value...
May 19, 2015 at 1:18 am
Raiserror can work with a string or an error number. If you use a string, the error number will be 50000. Here is a small example:
RAISERROR ('This...
May 19, 2015 at 1:05 am
If your server was installed as case sensitive, then you should use database master instead of Master.
Adi
April 28, 2015 at 3:19 am
No it won't. You'll have to rebuild it on your own.
Adi
April 28, 2015 at 3:14 am
Maybe I'm missing something, but you can set the deadlock priority in the procedure's code.
Adi
April 27, 2015 at 1:59 am
You can create a server group and then in one window in SSMS that is connected to the whole group run the script that creates or edits the procedures. ...
April 24, 2015 at 3:48 pm
I know that answering my own question is a bit strange, but I found out the problem and it might help someone else so I'm writing it as an answer...
March 6, 2015 at 7:23 am
When you rebuild a table, SQL Server modifies the value of column modify_date in sys.objects so it will have the value of the time that the table was rebuild. ...
January 12, 2015 at 5:02 am
Can you try this version and see if this works for you?
SELECT w.ItemId
,w.DateID
,w.OpenningWareHouseUnits
,w.FcastSales
,w.GoodsIncoming
,w.TargetRunningStock
, SUM(TargetRunningStock) over (partition by ItemId order by DateID ROWS UNBOUNDED PRECEDING) as RunningTotal
FROM #WareHouseData w
ORDER...
January 12, 2015 at 4:49 am
Viewing 15 posts - 76 through 90 (of 1,478 total)