Viewing 15 posts - 20,521 through 20,535 (of 26,484 total)
Krasavita (6/9/2009)
I want to know everything, what is ER diagram, can you create it in SQL Server?
An ER Diagram is a Entity-Relationship Diagram. There is no way we can...
June 9, 2009 at 8:21 am
Just a little thing, but may I suggest you write the query more like this:
select
database_name,
max(backup_finish_date) as backup_finish_date
from
msdb.dbo.backupset ...
June 9, 2009 at 8:14 am
karthikeyan (6/9/2009)
i expected this question from you. Since i studied these concepts just to pass the exams, beacuse that time i don't know the real time usage and it will...
June 9, 2009 at 7:12 am
Paul M. Corley (6/8/2009)
June 8, 2009 at 11:07 pm
What works for one server, my not work well for another. You really need to accomplish this more on a server by server basis. Every application will be...
June 8, 2009 at 4:15 pm
At this point, contact your network/server admin people. There are only two administrative terminal services connections available to a Windows Server. If you can't connect, then both connections...
June 8, 2009 at 1:52 pm
Why do you keep opening new threads? Use the original thread you first started. Continually open new threads is just going to get people upset, and you won't...
June 8, 2009 at 1:47 pm
Still waiting for an explanation as well as what the sample data SHOULD look like if it was sorted correctly.
June 8, 2009 at 1:45 pm
Please do not double post requests for help.
Please post any responses here.
June 8, 2009 at 1:25 pm
Sounds like you are trying to connect to your sql server system on one of the two remote admin terminal services connections and both are in use.
If you have a...
June 8, 2009 at 1:21 pm
Jeff Moden (6/8/2009)
Carl Federl (6/8/2009)
Perhaps I am missing something, but what is wrong with the system function "isnumeric" ?CREATE RULE [dbo].[NumericCharsOnly]
AS
ISNUMERIC(@value) = 1
GO
Here's one of many problems...
June 8, 2009 at 11:49 am
As long as you have the Builtin\Administrators account in SQL Server, anyone who is a member of that role will have SysAdmin access to that instance of SQL Server.
June 8, 2009 at 11:12 am
Care to elaborate on the problem a bit? What would really help is and explaination of your code (why the count() over, for one). Also, what is the...
June 8, 2009 at 10:47 am
Lowell (6/8/2009)
Msg 513, Level 16, State 0, Line 1
A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement....
June 8, 2009 at 10:39 am
GilaMonster (6/8/2009)
Tom Brown (6/8/2009)
June 8, 2009 at 10:21 am
Viewing 15 posts - 20,521 through 20,535 (of 26,484 total)