Viewing 15 posts - 91 through 105 (of 1,580 total)
It depends. Do you have a lot of clustered/non clustered indexes?
Take a look at your "data" column on a day-to-day basis, that will give you an idea of how...
March 18, 2015 at 8:49 am
Not sure if this is something you're looking for but I recently posted a process on SSC to track these types of things. Feel free to check it out...
March 17, 2015 at 4:29 pm
How about something like this?SELECT
OBJECT_NAME(referencing_id) AS referencing_object,
referenced_entity_name
FROM
sys.sql_expression_dependencies
WHERE
referenced_database_name IS NULL
AND is_ambiguous...
March 17, 2015 at 4:20 pm
Do you mean for procedures that are called within procedures i.e ("other" procedures get executed from within a calling procedure?)
March 17, 2015 at 11:35 am
+1 sql_lock!
March 10, 2015 at 12:04 pm
You can also find out if a table is replicated by running the query below on the publisherSELECT * FROM sys.tables WHERE is_replicated = 1
March 2, 2015 at 12:16 am
You may want to look at the sp_repladdcolumn
There's some discussion on it here:
http://www.sqlservercentral.com/Forums/Topic153870-71-1.aspx
February 10, 2015 at 1:21 pm
How big is the table?
If it's not too large it would be easier to drop the article and re-add it with the new columns (or all of them). This...
February 10, 2015 at 10:57 am
Assuming you are using windows authentication and you wish to only grant READ ONLY access, this should work: USE [master]
GO
CREATE LOGIN [DOMAIN\username] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [DatabaseYouAreGrantingAccessTo]
GO
CREATE USER [DOMAIN\username] ...
February 10, 2015 at 10:19 am
I'm terribly sorry Peter, I just don't know what else to offer - I'm very sorry:crazy:
February 8, 2015 at 10:31 pm
No, using this method there is no way to track the actual change made. You would need to either use a 3rd party monitoring tool or enable CDC. ...
February 3, 2015 at 8:12 am
There are many views on this, of which you can easily find via google 🙂 My personal stance (without knowing how the DB is actually used) is to size...
February 2, 2015 at 10:47 am
@sql Galaxy - you should be able to change the script to easily monitor a single server
February 2, 2015 at 7:44 am
jonathan.hickford (2/2/2015)
I've seen a few different change tracking systems, some using the default trace, and others using DDL triggers/ What are your (and others) thoughts about...
February 2, 2015 at 5:52 am
Viewing 15 posts - 91 through 105 (of 1,580 total)