Viewing 15 posts - 2,266 through 2,280 (of 3,738 total)
I do not see any DDL?
Could you include some with sample data?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 10, 2011 at 1:17 am
Maheshsoft1987 (9/9/2011)
I have checked it. Its seems like I have read write permission.
It seems like? That does not sound very convincing.
You said that the package would be using the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 4:46 pm
I saw on the the SQLShare Demos and they used a 3 hints.
They ran profiler, executed the queried and showed what the best hint was in this scenario.
Perhaps that was...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 4:33 pm
That is set in the Group Policy.
Perhaps this may provide you with some insight.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 4:26 pm
Duplicate Post.
http://www.sqlservercentral.com/Forums/Topic1172870-359-1.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 4:20 pm
Permissions to be set on the Server that is writing to Excel and the Second Server:
http://www.windowsecurity.com/articles/share-permissions.html
If you have issues log on using the Service Account and read a file and...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 3:16 pm
Did you test using you user Account or the SQL Server Agent Service.
Using Windows Explorer can you navigate to the UNC path and read write to the folder.
You said...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 2:58 pm
64 bit or 32bit?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 2:54 pm
What would be better yet if you provided the DDL and sample Insert Statement.;-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 2:07 pm
I'm having a little trouble on what youi are doing other you want to extract Data From SQ Server to Excel.
Why don't you try doing real quick ussing the SSIS...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 2:01 pm
ops. Your suggestion to restore from a backup is good.
I would restore to a non-production server and load the table via SSIS.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 8:03 am
What I would suggest as a work around would be to script out the table and modify it to the new name.
Then load it via a query or the SSIS...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 7:48 am
I could have swored I did this last night (early morning) but I got an error. :w00t:
2008.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 7:45 am
If you are going to take 8GB from the Database and archive it to a Database on the same Server then you are not accomplishing anything with respect to space.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 7:41 am
HowardW (9/9/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2011 at 7:33 am
Viewing 15 posts - 2,266 through 2,280 (of 3,738 total)