Viewing 15 posts - 4,666 through 4,680 (of 6,676 total)
I wouldn't necessarily ignore the date - just understand that it is going to be unique based upon UTC time instead of local time. You still have to have...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 7:50 am
Jeffrey Williams (8/17/2009)
This was not an...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 3:56 pm
santosh.shrestha (8/17/2009)
CREATE TABLE Temp1 (
Aa varchar(10),
Bb varchar(10),
Cc varchar(10),
Dd varchar(10),
Ee varchar(10),
Ff varchar(10),
Gg varchar(10),
Hh varchar(10)
)
Now let us insert some thing in table so
INSERT INTO Temp1...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 3:36 pm
And, after running those - what are your conclusions? Or did you just run them and paste the results here for me to interpret?
This was not an exercise for...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 3:03 pm
I think we should really consider what the OP really wants to be able to accomplish. Most likely, they are looking for a way to have multiple default instances...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 2:43 pm
santosh.shrestha (8/17/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 2:09 pm
andersonrj18 (8/17/2009)
Why don't you simply create a synonym.create synonym table_name for user.table_name
select * from table_name
Even with a synonym - you are going to have to same issues. The recommendation...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 2:02 pm
Elliott W (8/17/2009)
Perhaps I'm being too semantic, I see default as if you install the product and do nothing else you can always count on the port being 1433 for...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 2:01 pm
Run the following and see what you get:
SELECT getdate(), getutcdate();
SELECT datediff(hour, getdate(), getutcdate());
SELECT dateadd(hour, 7, '20090817 08:00:01');
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 1:53 pm
samsql (8/17/2009)
Thankz lynn but i want to know bcoz i hav read some were that we can do that without specifying the schema ... can u help me in this
If...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2009 at 1:47 pm
Why don't you follow the advice in the error message and enable remote errors?
http://msdn.microsoft.com/en-us/library/aa337165(SQL.90).aspx
My recommendation would be to create a shared data source on the server and then modify your...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 16, 2009 at 3:35 pm
bpowers (8/15/2009)
How would I get this to work?SELECT EMP_ID, DATEDIFF(MONTH, START_DATE, END_DATE) AS HISTORY
FROM EMP_HISTORY
WHERE EMP_ID = '253'
What doesn't work with the above? You can't just ask us to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 3:47 pm
GilaMonster (8/15/2009)
Jeffrey Williams (8/15/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 2:45 pm
DATEDIFF(day, '20070101', '20090101')
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 2:10 pm
And to further what Gail has stated - in SQL Server 2005, the passwords for SQL authenticated accounts will use the servers password policies by default. That is, if...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 1:57 pm
Viewing 15 posts - 4,666 through 4,680 (of 6,676 total)