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...
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....
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,...
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...
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...
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
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...
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...
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?
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.
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...
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...
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
February 7, 2013 at 6:28 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...
February 6, 2013 at 6:03 am
Viewing 15 posts - 1 through 15 (of 46 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy