Viewing 15 posts - 676 through 690 (of 1,131 total)
Do you have SQL Server Service Pack 4 for the Client tools installed ?
SQL = Scarcely Qualifies as a Language
February 28, 2007 at 2:59 pm
A few means of diagnosing the problem:
a) Use SQL Profiler to capture event "Login Failed" (under "Security Audits") and columns loginame and hostname.
Then try to connect and Profiler...
SQL = Scarcely Qualifies as a Language
February 26, 2007 at 7:09 pm
From Books On line, for three data types, the storage bytes and maximum value are listed below. Also provided are the number of years before the maximum value is...
SQL = Scarcely Qualifies as a Language
February 25, 2007 at 4:51 pm
Please provide DDL and sample data and do not provide narrative and listings. http://www.aspfaq.com/etiquette.asp?id=5006
The real problem is that the table are not normalized. In this case, the "CourceGroup"...
SQL = Scarcely Qualifies as a Language
February 25, 2007 at 2:53 am
set @SqlString = N'select @Column_name = Column_Name from information_schema.columns where table_name = ''' + @Table_Name + ''' and Ordinal_position = ' + @Counter
This set statement is intended to append...
SQL = Scarcely Qualifies as a Language
February 23, 2007 at 4:45 am
As a rule of thumb, when joining, the on criteria will be the primary key of one table equal to the foreign key of the other table.
If you are not...
SQL = Scarcely Qualifies as a Language
February 22, 2007 at 4:55 pm
I can reproduce your problem by setting the some environmental options by running either:
set dateformat dmy
set language British
You seem to be expecting this option to be mdy.
Run DBCC USEROPTIONS to...
SQL = Scarcely Qualifies as a Language
February 22, 2007 at 4:49 pm
" i want to deliver mdf file in the cd and my software will attach it , but i want to limit that no one can attach it in...
SQL = Scarcely Qualifies as a Language
February 22, 2007 at 1:29 pm
Please do not post in more than one forum.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=346521
SQL = Scarcely Qualifies as a Language
February 21, 2007 at 5:32 pm
Your requirement statement is too vague to define a soulution
Please provide DDL and sample data including the "model office" table, the condition table and the "model office condition" table. ...
SQL = Scarcely Qualifies as a Language
February 21, 2007 at 5:16 pm
"Has anyone had trouble using and backing up 300GB + databases in one file? "
With a SAN, not using large database specifically.
For backups of larger databases, recommend performing parallel backups...
SQL = Scarcely Qualifies as a Language
February 16, 2007 at 1:04 pm
To diagnose, run SQL profilier and monitor events for logins including failures, sql:batchcompleted and sql:batchstarting
This will capture the exact SQL being issued by the application and any error messages.
SQL = Scarcely Qualifies as a Language
February 16, 2007 at 12:51 pm
"I also tried using sp_MSforeachdb to no avail"
You need to be aware of the parameter @replacechar, which defaults to '?'. Try this SQL:
if object_id('tempdb..#Objects') is not null drop table...
SQL = Scarcely Qualifies as a Language
February 15, 2007 at 10:43 am
Here is some SQL that you can run:
-- For logins
Setnocount on
Selectcast( serverproperty ('machinename') as nvarchar(128) )as machinename
,coalesce ( cast( serverproperty ('instancename')as nvarchar(128) ) , 'default')as instancename
,loginname
,createdate
,updatedate
,dbname
,language
,denylogin
,hasaccess
,isntname
,isntgroup
,isntuser
, password
From master.dbo.syslogins
go
-- Server...
SQL = Scarcely Qualifies as a Language
February 14, 2007 at 11:07 am
There are quite a few fixes for indicies on columns with a datatype of bit.
Do you have Service Pack 4 installed ?
SQL = Scarcely Qualifies as a Language
February 14, 2007 at 9:48 am
Viewing 15 posts - 676 through 690 (of 1,131 total)