Viewing 15 posts - 46 through 60 (of 92 total)
I thought so :-)..someone will ask me to post in new post.
Gail..please respond to below post..Thanks in advance
http://www.sqlservercentral.com/Forums/Topic867792-1550-1.aspx
February 18, 2010 at 1:27 am
I read many articles and in forums that often shrinking the DB is not a good practise...and I agree to it considering the impact DB may have in long run....
Somebody...
February 18, 2010 at 1:07 am
The terms Database and Instance are different in Oracle and SQL.
In SQL in an instance there can be 'N' number of databases.
In SQL there is database which can have multiple...
February 17, 2010 at 1:25 am
Nope..this is not the error shown at step 1...this is error shown at step 0...Post the error shown at Step 1...
expand the Job history and look for the error at...
February 16, 2010 at 11:27 pm
Whats the error shown in Step 1 of job..post it here
February 16, 2010 at 11:15 pm
Few things:
1) INSERT INTO MYTABLE@SQLSERVER ("Id","Name") VALUES (1,'Fred');
doesn't look like compatible to insert syntax for MSSQL
Meaning
MYTABLE@SQLSERVER...is not MS SQL syntax
MYTABLE.SQLSERVER ..is correct syntax
2)Configure your Oracle Server as Linked server in...
February 16, 2010 at 5:19 am
Thanks Sanket for the link...gr8 site
February 16, 2010 at 3:43 am
Thanks Mutthu...this goes to my briefcase.:satisfied:
February 11, 2010 at 5:38 am
Thanks Paul...for the article...its well described still easy to understand..
February 11, 2010 at 2:02 am
Josef, thanks for the article...I learned about included columns..
February 11, 2010 at 1:31 am
GT,
you CAN'T backup tempdb
February 10, 2010 at 10:29 pm
I think you should Move the data into the file system and have reference to it in the DB
February 10, 2010 at 3:35 am
Go through below links:
http://www.sqlservercentral.com/Forums/Topic471017-169-1.aspx
http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/
February 10, 2010 at 1:02 am
Did you checked what your job is doing?...in most of the cases thats the reason which I posted earlier for such error.
February 9, 2010 at 4:08 am
Viewing 15 posts - 46 through 60 (of 92 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