Viewing 15 posts - 2,431 through 2,445 (of 3,738 total)
I'm assume that you can connect locally?
Make sure that remote connections check box is checked and that TCP/IP is enabled.
For instructions refer to the following
http://www.sqlservercentral.com/Forums/Topic1085068-391-1.aspx
August 17, 2011 at 10:35 am
Looks like a homework assignment to me and not a very good one at that.
August 16, 2011 at 4:15 pm
Does the Service account are you using to run this job have the proper permissions?
August 15, 2011 at 10:39 pm
Yes a check constraint is used for validation of columns in one table (To check the values).
If you want to change the value of a column then you would need...
August 15, 2011 at 11:09 am
Your constraint seems very odd but if you want help you should include your DDL.
August 15, 2011 at 10:25 am
rpadma2 (8/15/2011)
August 15, 2011 at 9:39 am
Perhaps I'm missing something I do not see the actual error?
August 14, 2011 at 9:59 pm
Every time I perform adhoc updates in production I create a copy of a table when I also wrap the changes in a transaction and rollback if necessary and commit...
August 13, 2011 at 6:51 am
If you run the wizard it creates an SSIS package, creates the schema and copies the data.
Have you tried right clicking on the database, selecting tasks, selecting export data and...
August 12, 2011 at 10:28 pm
If you right click on the database from SSMS and Select , Select the objects that you want to transfer and Export Data and run the wizard to copy the...
August 12, 2011 at 10:07 pm
The following post may be of help to you.
http://www.sqlservercentral.com/Forums/Topic864318-148-1.aspx#bm864417
August 12, 2011 at 9:50 pm
laddu4700 (8/12/2011)
I tried to restore sql server 2008 R2 database backup file in sql server 2008 sp2 server, but it failed with error.
"The database was backed up on a server...
August 12, 2011 at 9:26 pm
I did not intend to offend anyone.
I just thought that this could be a practice exercise in the event of a issue in the future.
I prefer Lightspeed to perform...
August 12, 2011 at 3:55 pm
Good thing you had a backup. 🙂
Just wondering but why did you decide to perform a SELECT INTO and subsequently TRUNCATE the table?
August 12, 2011 at 2:39 pm
Perhaps I misunderstood but I did not interpret that inserting the records from EMP_BKP into EMP is the desired solution.
August 12, 2011 at 1:29 pm
Viewing 15 posts - 2,431 through 2,445 (of 3,738 total)