Viewing 15 posts - 5,146 through 5,160 (of 6,400 total)
Yep it is. If you right click the database you wish to import into, then in the tasks menu you should see Import Data.
May 10, 2012 at 1:19 am
the only way to pause would be to add a WAITFOR DELAY into the stored proc. It would leave that SPID open so if its doing things inside a...
May 10, 2012 at 1:14 am
Yes, there are many different ways to do this. You have the Import/Export data wizard, bulk insert commands, bcp and SSIS.
If its going to be a 1 time thing...
May 10, 2012 at 1:10 am
durai nagarajan (5/9/2012)
The drives that you proposing can i know it deeply, we have a virtual server and base configuration i dont have if i ask them to add a...
May 9, 2012 at 8:24 am
Hi and welcome to SSC, please could you follow the second link in my signature block and post the table definitions, sample data and your expected output of based on...
May 9, 2012 at 6:50 am
After changing my search terms fo SSIS Google Analytics some kind developer has written a plugin for GA which can be found here http://analyticssource.codeplex.com/. All you need to do...
May 9, 2012 at 6:42 am
HowardW (5/9/2012)
May 9, 2012 at 5:37 am
does this help
declare @results xml
set @results = (select name from sysobjects for XML AUTO)
select @results
May 9, 2012 at 4:42 am
Sony Francis @EY (5/9/2012)
Any way other than replication ?Replication requires additional hardware( subscriber and distributer server). Expensiveeee!!!!!!!!!
the publisher and distibution server can be the same box, so that would...
May 9, 2012 at 4:33 am
is the database stored on many different computers or is it on one central server?
if its on a server and you want it to backup to a users workstation you...
May 9, 2012 at 4:25 am
the main thing to worry about is how often the table is updated as if you have set the FTC to be change tracking automatic then each update insert delete...
May 9, 2012 at 4:22 am
yes they are stored like any other index, you can query the space in the GUI by clicking properties of the FTC under the storage node in SSMS and look...
May 9, 2012 at 4:12 am
ensure that the account which is running the SQL service has the nessesary rights to write a file into the locations you wish for it to go.
May 9, 2012 at 3:23 am
To add on from the above, does the user exist in the database it needs to connect to.
If your using SQL authentication, has the DB been refreshed from a different...
May 9, 2012 at 1:46 am
firstly if you can get more drives added to the server
i've seen some people say that with the system databases (excl TempDB) that the MDF and LDF are ok on...
May 9, 2012 at 1:41 am
Viewing 15 posts - 5,146 through 5,160 (of 6,400 total)