Viewing 15 posts - 1 through 15 (of 46 total)
You should be able to add a new table in the publishing database, make sure it is selected in the Publication Properties under the "Articles" page. If you have a...
______________________________
AJ Mendo | @SQLAJ
May 21, 2013 at 5:00 am
You can only specify SA and Service accounts/passwords during install. After install is when you create regular users. Unless you are talking about adding a new user as a sysadmin....
______________________________
AJ Mendo | @SQLAJ
February 25, 2013 at 6:30 am
At some point you will need to do some work yourself. If you need to set max size, then YOU need to find out how much the database is growing,...
______________________________
AJ Mendo | @SQLAJ
February 20, 2013 at 8:00 am
Use something like this script to monitor the size and free space of the files.
Setup a job that runs everyday/week insert into a database to monitor/track over time, send you...
______________________________
AJ Mendo | @SQLAJ
February 18, 2013 at 11:10 am
Look at your error. There appears to be a security issue.
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536.
The server may be running...
______________________________
AJ Mendo | @SQLAJ
February 18, 2013 at 7:13 am
Ranzz,
Take a look at this post. It has some code you can use and shows some examples of alerts.
http://www.sqlmag.com/blog/practical-sql-server-45/sql-server-2012/disk-space-monitoring-143552
______________________________
AJ Mendo | @SQLAJ
February 17, 2013 at 7:37 am
Group A - Grant admin permissions - Server and Database level permissions
Group B - Grant Select / Execute - Database level permissions.
Using database mapping for the group only needing Select...
______________________________
AJ Mendo | @SQLAJ
February 16, 2013 at 6:51 am
Ranzz (2/15/2013)
I need help on setting up alters when the database (files MDF, NDF & LDF) reaching the MAX size.
If anybody have some thing please share, I...
______________________________
AJ Mendo | @SQLAJ
February 16, 2013 at 6:35 am
You mentioned you disabled the job but what does it do? Has it completed?
Are there any errors in the logs when disabled it?
______________________________
AJ Mendo | @SQLAJ
February 16, 2013 at 6:27 am
Take a look at this post. It gives some good information and a starting place for further investigation/reading.
______________________________
AJ Mendo | @SQLAJ
February 14, 2013 at 9:39 am
I don't believe I said,
"will clearly and certainly make a different entry for ONLY the last row inserted."
I was only trying to provided some information in order to help to...
______________________________
AJ Mendo | @SQLAJ
February 11, 2013 at 11:37 am
Use default argument for the column.
"DEFAULT
Specifies the value provided for the column when a value is not explicitly supplied during an insert. DEFAULT definitions can be applied to any columns...
______________________________
AJ Mendo | @SQLAJ
February 10, 2013 at 7:31 am
Have you looked at this? Should be all you need.
http://msdn.microsoft.com/en-us/library/ms142511(v=sql.90).aspx
______________________________
AJ Mendo | @SQLAJ
February 7, 2013 at 6:28 am
Cool!. Glad to help.
______________________________
AJ Mendo | @SQLAJ
February 7, 2013 at 4:58 am
You did not indicate what version of SQL so I am basing this information on what I have currently running SQL 2008 R2.
There are several settings that can indicate which...
______________________________
AJ Mendo | @SQLAJ
February 6, 2013 at 6:03 am
Viewing 15 posts - 1 through 15 (of 46 total)