Viewing 15 posts - 10,156 through 10,170 (of 49,569 total)
If the table is not in the user's default schema nor is it in dbo, you'd need to qualify the table name with the schema name to access it.
January 31, 2014 at 12:20 am
free_mascot (1/30/2014)
In addition resource of the server too may be affected i.e. CPU, MEMORY, I/O etc.
Extended events are pretty light-weight. Trace, providing it's a server-side trace shouldn't be too bad,...
January 30, 2014 at 11:03 pm
Looks like the restrictions against non-deterministic functions has indeed been relaxed.
CREATE FUNCTION dbo.OffsetDate(@Offset INT)
RETURNS DATETIME AS
BEGIN
RETURN DATEADD(hh,@Offset, GETDATE())
END
GO
SELECT dbo.OffsetDate(3)
January 30, 2014 at 12:18 pm
Firstly don't call it getdate (even if you can), second I think you'll have to pass two parameters, the offset and the datetime you want the offset to apply to.
January 30, 2014 at 11:34 am
Nadrek (1/30/2014)
I'd suggest taking a hash of the actual backup file before the first copy, and then checking it after each copy - if it's different, then re-copy.
No need, if...
January 30, 2014 at 10:55 am
BriPan (1/30/2014)
3 or max 7 . and they also having same...
January 30, 2014 at 10:43 am
DominantDBA (1/30/2014)
So the network copy from B to C was corrupted
Not necessarily. I gave two possibilities.
January 30, 2014 at 10:42 am
Ryan George (1/30/2014)
as per the requirement, it is asked to create a table with two primary keys. how can we implement the same
At the risk of sounding like an echo...
A...
January 30, 2014 at 10:40 am
Extended events or SQL Trace can both do that. Be aware you're going to have a HUGE amount of data to deal with, store and process.
January 30, 2014 at 7:09 am
A table cannot have two primary keys. Sure the requirement isn't for a single primary key consisting of two columns?
January 30, 2014 at 7:08 am
DuncEduardo (1/30/2014)
January 30, 2014 at 6:07 am
polkadot (1/30/2014)
are you suggesting that instead of Unique Index I make the column a Primary Key?
If the table doesn't already have a primary key, yes.
January 30, 2014 at 6:06 am
Encrypt in the application, not the database. It also prevents any sysadmin from just decrypting it, which they can do if you use keys protected by database permissions. Of course,...
January 30, 2014 at 5:41 am
Please don't cross post. It just fragments replies and wastes people's time as they answer already answered questions.
No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1536266-359-1.aspx
January 30, 2014 at 5:34 am
DuncEduardo (1/30/2014)
January 30, 2014 at 5:33 am
Viewing 15 posts - 10,156 through 10,170 (of 49,569 total)