Viewing 15 posts - 4,801 through 4,815 (of 7,187 total)
Set up a server-side trace to monitor tempdb data file growth events as well as general server activity and see whether there's anything obvious that's happening every time the file...
January 16, 2012 at 8:37 am
Use a UNC path to access files across the network. Make sure the account that runs SQL Server has permissions on the files.
John
January 13, 2012 at 5:42 am
I think it's best to play safe here. That way you don't have to worry about aliases, registry entries and other things not getting changed.
Install a new SQL Server...
January 13, 2012 at 4:54 am
Beware of issues with permissions caused by ownership chaining when writing cross-database views. This Microsoft article is worth reading.
John
January 13, 2012 at 4:45 am
Have you looked in the Progress tab and found no error messages? Another thing you can do is double-click on the data flow task (while still in debug mode)...
January 12, 2012 at 7:55 am
I take it that means you have a Sort transformation in your data flow instead? What makes you think your data isn't being sorted properly?
John
January 12, 2012 at 7:01 am
What is the value of @[User::JurisID] at runtime?
John
January 12, 2012 at 1:54 am
sunilreddyat (1/11/2012)
try to change the datatype from varchar(max) to nvarchar(max) and change the source datatype to ntext
Is there any particular reason why you think that'll work? I can't check...
January 11, 2012 at 8:18 am
First, don't use sp_change_users_login. It's deprecated. And it doesn't support Windows Logins, or SQL Logins (one or the other, I can't remember which).
Second, since all the users are...
January 11, 2012 at 7:30 am
More information needed, please. Are all the users in the same database? Do all users have the same name as their respective logins?
John
January 11, 2012 at 4:30 am
khushboo.dudani (1/10/2012)
But it is not working.
How is it not working? Error message? What is the error message? Data not transformed as you expected? How is the...
January 11, 2012 at 4:28 am
Have you checked the SQL errorlog and the Windows evenlog for error messages?
John
January 10, 2012 at 8:45 am
What is the data type of the column you're importing the data in to?
John
January 10, 2012 at 8:40 am
Dev (1/10/2012)
Please check for column separator. It looks like ‘ ‘(space) character is breaking the rows in multiple columns.
Mmmm... that doesn't explain why the second and third rows...
January 10, 2012 at 8:37 am
Are you running the package interactively (through BIDS)? Are there any Warning messages on the Progress page?
John
January 10, 2012 at 8:34 am
Viewing 15 posts - 4,801 through 4,815 (of 7,187 total)