Viewing 15 posts - 4,801 through 4,815 (of 7,191 total)
I'm stumped, then. The only thing I can think of for you to try is create the table without the foreign key, then use ALTER TABLE to add...
January 17, 2012 at 8:28 am
Can't see anything wrong with that. Does the statementHistory table definitely exist when you are trying to create the categories table?
John
January 17, 2012 at 8:16 am
As Paul and Cadavre have already asked, post your table DDL and some sample data and it'll be a lot easier for us to help you.
John
January 17, 2012 at 7:02 am
Or maybe...
WITH CTE AS (
Select wrp_sys_User.IntUserId, wrp_sys_User.chrForename + ' ' + wrp_sys_User.chrSurname as chrFullName, U.intUserID, U.chrUnAllocatedUser
from wrp_team inner join wrp_TeamUser on wrp_Team.intTeamID = wrp_teamUser.intTeamID
inner join wrp_sys_User on wrp_teamUser.intUserID = wrp_sys_User.intUserID
inner...
January 17, 2012 at 6:49 am
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
Viewing 15 posts - 4,801 through 4,815 (of 7,191 total)