Viewing 15 posts - 2,416 through 2,430 (of 3,232 total)
Yes, Lowell is correct. There are only a few options here. Either the program HTTP.exe does not exist, or it cannot be found in your PATH. If you do have...
February 9, 2007 at 3:58 pm
You cannot have a variable of any data type except type TABLE in a FROM clause in a DML statement. A table variable is not a variable that hold the table...
February 8, 2007 at 3:56 pm
I'm a bit confused by your ActiveX script. Did you say that you have a data pump task? From your initial post, I was under the impression that you had...
February 8, 2007 at 3:48 pm
If you need to dynamically popluate a destination column from another table, you need to use a lookup. Have you tried this yet?
February 8, 2007 at 12:28 pm
I guess I don't quite follow what you are saying. Can you describe in more detail your multiple file scenario?
February 8, 2007 at 10:46 am
This should do it:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=342506
February 8, 2007 at 9:17 am
Yes, the browser comes in very handy and saves you from having to remember (and type) all of your object names.
February 5, 2007 at 10:04 am
I the data pump, view the transformations. Delete your existing transformations and create a new one. You will be prompted for the type of transformation you would like to create,...
February 5, 2007 at 9:47 am
It may also help if you post the execution plans or at least tell us what the differences are.
February 2, 2007 at 3:53 pm
Have you tried to register the local SQL Server in EM? If your Domain User account has been added as a local admin, I doubt it is a permissions issue...
February 2, 2007 at 3:50 pm
SQL Server will more often than not use all of the memory available to it. I can see on a system that is not very busy or where the requests...
February 2, 2007 at 3:43 pm
With 16 GB, I woud give at least 14 GB to SQL Server. I don't know if it is a rule of thumb or not, but I will usually give...
February 2, 2007 at 3:32 pm
Use UNC paths and Windows security instead of mapped drives.
February 2, 2007 at 1:43 pm
I would suggest creating a numbers table and using a split function if you don't already have one. Search this site for dbo.Split and you should find plenty of posts...
February 2, 2007 at 1:11 pm
Viewing 15 posts - 2,416 through 2,430 (of 3,232 total)