Viewing 15 posts - 11,911 through 11,925 (of 13,461 total)
i found this link with a simple search:http://www.alpesh.nakars.com/blog/unattended-sql-server-2005-installation/
i also second guessed that by unattended installation, you might have meant "install sql2005 with my application"
which you can get more info...
November 6, 2008 at 5:08 am
just checking the basics....are you using a full path in the query, for example
select * from ServerB.DbName.dbo.Employees where Ename='Bob'
could you please show a sample query, where a table exists in...
November 6, 2008 at 5:00 am
when you restore a database on a DIFFERENT server, you get something called "orphaned users" ; remember a database with a login "Bob" on my server is not the same...
November 5, 2008 at 6:16 pm
if you think you need a cursor in a trigger, you're always, and i mean ALWAYS, looking at the problem wrong.
one of the new feature sin SQL2005 is the COLUMNS_UPDATED...
November 5, 2008 at 10:09 am
SELECT DISTINCT [Name],[Date Of Birth]
FROM [zzWembley WIC 2ND QTR 2008]
I get 2664 records with one record null
this implies that there are people who have the same name, but are...
November 5, 2008 at 9:53 am
the mdf file is open and held open by sql server....only by stopping the SQL Server service would the file date get refreshed....changes happen, but the file is never "closed"...
November 5, 2008 at 6:50 am
I looked in the registry on my machine, and I think this is where you want to go to delete old servers you no longer connect to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect
mine has a list...
November 5, 2008 at 6:46 am
if you are lucky, you can hope for a couple of design standards that could make it easier.
IF you can assume that FK columns have the same name as it's...
November 5, 2008 at 6:22 am
the CDO object has the ability to send the SMTP user And password, but the default procedure
sp_send_cdosysmail does not have parameters for it;
if you don't have the sp you...
November 4, 2008 at 7:57 am
do not cross post the same question in different forums.
follow the thread here:
http://www.sqlservercentral.com/Forums/Topic596429-146-1.aspx
November 4, 2008 at 7:42 am
do not cross post the same question in different forums.
follow the thread here:
http://www.sqlservercentral.com/Forums/Topic596429-146-1.aspx
November 4, 2008 at 7:41 am
as an example, I'd forget trying to restart the object number as restarting at 1 with a category break, and just generate a number based on Category and item
to...
November 4, 2008 at 7:28 am
i don't really like the structure of your table; you are really assuming that you will be inserting the header "T shirts" at the same time as all it's...
November 4, 2008 at 7:12 am
Viewing 15 posts - 11,911 through 11,925 (of 13,461 total)