Viewing 15 posts - 91 through 105 (of 1,583 total)
What does the sp on SQLA do? Just a SELECT? INSERTS? ETC?
Also, what version of SQL?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 20, 2015 at 10:31 am
Awesome! Please be sure to set the autogrowth setting to "In Megabytes", and not "In Percent", and as SQLBill mentioned, ensure the "Maximum File Size" is set to a...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2015 at 9:02 am
If your database is full, you need to add more space. Rather than making it a manual process, simply enable the autogrowth setting to something "reasonable" (and get rid of...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2015 at 1:53 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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?)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2015 at 11:35 am
+1 sql_lock!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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] ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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. ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 2, 2015 at 10:47 am
Viewing 15 posts - 91 through 105 (of 1,583 total)