Viewing 15 posts - 571 through 585 (of 966 total)
Seems fine. If you manually run the job for the subplan does the step still fail? You may have to run a trace to see what is going on during...
October 29, 2012 at 12:38 pm
But my main question is if the Initial size is 70 GB can the consumed be 3 mb? I have seen this case happening with Tempdb last week.
You can set...
October 29, 2012 at 12:32 pm
Look at the SQL logs. It should show what parameters were used when the instance started. Can you list those?
Alternatively it should also be listed in the startup parameters if...
October 29, 2012 at 12:03 pm
That is strange. Never seen that before. Do you also get no records returned if you run the following query:
USE master
GO
SELECT * FROM sysobjects WHERE name LIKE '%fn_get_sql%'
October 29, 2012 at 11:52 am
A few more questions:
- How many IP addresses is SQL configured to listen on?
- Are there multiple NICs on the server?
- Is NIC teaming used on the...
October 29, 2012 at 11:31 am
This is because quotation marks in SQL are done in pairs. In order to have a single quotation mark show up in your select statement it has to be escaped....
October 28, 2012 at 5:13 pm
I think you can only do up to the first 200 rows with that.
October 28, 2012 at 4:49 pm
What edition of SQL 2000 are the production instances that are missing this function? Is the account that you are looking with in the sysadmins server role?
October 28, 2012 at 2:23 pm
Do you get any error message?
I agree totally. No one can provide assistance unless we know the specifics of what is going on.
October 28, 2012 at 2:04 pm
On the mirror that you cannot drop (but after it was already removed on the primary), what happens if you issue the following:
RESTORE <database_name> WITH RECOVERY
If it succeeds you should...
October 28, 2012 at 2:01 pm
I don't think you can. You're going to need to do it using a DML statement in a query editor window.
If you provide the DDL of the table(s), sample data,...
October 28, 2012 at 1:45 pm
I have installed sql server 2005 express management studio.
What you installed is just a management tool. It is useless unless there is a database engine for it to connect to....
October 28, 2012 at 1:36 pm
Each environment (and instance of SQL) is going to have different administrative tasks that are going to need to be done at different intervals (daily, weekly, monthly, etc.). Some that...
October 28, 2012 at 1:26 pm
Interesting. I have never experienced anything like this. Is this same result experienced on other computers as well, or just yours? There is not a SQL alias setup on your...
October 26, 2012 at 4:13 pm
Intersting development I tryed to connect from SSMS using the FQDN and it does connect! (I thougt I tried that previously, guess I didnt) Any idea what that means? Seems...
October 26, 2012 at 3:32 pm
Viewing 15 posts - 571 through 585 (of 966 total)