Viewing 15 posts - 2,836 through 2,850 (of 3,738 total)
grovelli-262555 (6/20/2011)
What's a timestamp and how do you add it to every table?
Please refer to the following article:
http://www.sqlteam.com/article/timestamps-vs-datetime-data-types
June 20, 2011 at 6:08 am
Is it too late to normalize Table1?
Just wondering but what is the definition of the "Spend" Column?
Which Sales Rep is the Spend Column associated with, all of the Sales Reps...
June 19, 2011 at 7:36 pm
mister.magoo (6/19/2011)
Welsh Corgi (6/19/2011)
sqlfriends (6/19/2011)
So I think the script helps in some degree, but I still cannot decide if the former database is in use or not.
Have you tried what...
June 19, 2011 at 7:11 pm
sqlfriends (6/19/2011)
So I think the script helps in some degree, but I still cannot decide if the former database is in use or not.
Have you tried what I suggested?
You could...
June 19, 2011 at 7:03 pm
You can also use SP_who, sp_who2 or sp_who3 (requires download) and you can quickly identify all Connections to each database, the Login and the Application, etc.
Try it.
June 19, 2011 at 6:38 pm
sqlfriends (6/19/2011)
So I think I may check more into this.
I believe that you were provided an adequate solution to your problem so I'm not sure what additional checking is required?
June 19, 2011 at 6:29 pm
You could use CDC or CT depending upon your requrements.
The following article may be helpful to you:
June 19, 2011 at 6:25 pm
The SQL Litespeed GUI is relatively easy.
If you are not familiar with it I recommend that you get acclimated with it.
Why not try it?
June 19, 2011 at 4:44 pm
You probably don't have permissions to perform this?
Is there a Group Policy that could be preventing you?
What user are you using to perform the installation and are they a System...
June 19, 2011 at 4:16 pm
The following URL includes an example of Conditional Joins:
http://stackoverflow.com/questions/4522101/sql-server-2005-2008-conditional-join
June 19, 2011 at 4:07 pm
Jefy,
Please try the following post:
Welsh
June 19, 2011 at 3:26 pm
walterjone96 (6/16/2011)
June 19, 2011 at 2:53 pm
Duncan Pryde (6/13/2011)
Welsh Corgi (6/13/2011)
Duncan Pryde (6/13/2011)
I used UserName as a primary key in all tables, but UserID would work equally well.
Duncan
UserID would probably be the better option since it...
June 19, 2011 at 2:35 pm
Viewing 15 posts - 2,836 through 2,850 (of 3,738 total)