Viewing 15 posts - 436 through 450 (of 1,253 total)
I agree with Michael about renaming tables. It can get very tricky unless you are sure that nobody is running any queries against them while renaming. There is also...
January 14, 2009 at 4:57 am
sp_who & sp_who2 give info about users currently logged in.
For getting the info about how many times a user logs in/out you will need a trace.
January 14, 2009 at 4:45 am
I agree with Paul. These are difficult times and the new idea must be really good to make it work. Initially they may have to struggle a bit, but if...
January 14, 2009 at 2:30 am
To check locks you will have to use Profiler and start a trace.
Another way is using the DBCC TRACEON command. This will put block information in SQL...
January 14, 2009 at 1:52 am
Nice one Mark...
Rarely see someone outdo Jeff ....:)
January 13, 2009 at 11:42 pm
I use VSS 6.0 integrated with SQL 2005. Hav'nt come across any issues, but we are only 3 people working on it.
January 13, 2009 at 1:04 am
You will hv to check locking/blocking.
January 13, 2009 at 12:50 am
Disable the Fkeys, BULKINSERT the data and then enable the Fkeys. For this approach you need to sure that the data being appended will not break any Fkey relationships. Otherwise...
January 13, 2009 at 12:46 am
Anything SQL Server error logs. Is there sufficient memory.
Any network issues that you know of?
January 12, 2009 at 11:49 pm
This query returns the column name,datatype and length of the columns of a particular table.
select s.name , t.name ,s.max_length
from sys.columns s inner join sys.types t on s.system_type_id = t.system_type_id
where object_name(object_id)...
January 8, 2009 at 4:30 am
I hope you have'nt used any of the new features in SQL 2005 which will require code changes. If you have used you will need to make code changes.
January 7, 2009 at 11:43 pm
True. One to One relationship exists only for the good "one" address.
January 5, 2009 at 10:56 pm
RBarryYoung (1/5/2009)
This should do it:
Declare @sql Nvarchar(MAX)
Set @sql = N''
Select @sql = @sql + N'
EXEC sp_help ''['+TABLE_SCHEMA+N'].['+TABLE_NAME+N']'';'
From INFORMATION_SCHEMA.TABLES
Print N'Executing:
'+@sql+'
'
EXEC(@sql)
🙂
January 5, 2009 at 10:43 pm
Viewing 15 posts - 436 through 450 (of 1,253 total)