Search results for query: *

For anyone's interest, I solved my own problem. The day before I added a column name to the table, thus the sysobjects did not reflect this. Solution: copy table to another name, check to make sure new table is there, drop old table rename new table. Fun out of the sun with MS

I have been using linked servers for over a year on this particular stored procedure that generates a temporary table from a select as such: select * into #temp from server.database.owner.table I get an error message: Server: Msg 7353, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB'...

How about if you wanted to use a variable, say find the max len of a column then use the variable for the new size of a column, when I try this I get incorrect syntax. alter table temp alter column abc char(@newSize)

When you restart the SQL Server the Model Database overwrites the Tempdb. This may help.

I may be misunderstanding but if you do not want wither Act or County in the pa2.df_institutionname, use an AND in replace of the OR

I think I found your problem. The problem resides with both the dbcc shrinkfile and the exec backup log lines. I created a stored procedure that works and I changed the name with fileid, and used [] for the exec backup log line. See if this works for you use something like exec sp_shrink_log...

It sounds like your restore did not finish, due to lack of hard drive space. I would clear up some space and retry the restore. Your default is database is not there therefore MSSQL is going to the master instead.

Hi, I use SQL-97, but this should work: select * from locations.dbo.street a join hardware.dbo.equipment b on a.addressid=b.addressid

Sorry for misreading Josh. rajeevnandanmishra, that was a very insightful query, thanks!

select * from test where column1 like '%str%'

Hi I am running slq97 and tried thsi create table temp1 (my_date smalldatetime null) insert into temp1 values(null) select * from temp1 It seems to work, maybe I am misunderstanding something. Let me know. Chuck

Hi Edmundo, I know you were looking for a solution other than the use of CharIndex, but here is one with CharIndex. I tested it and it works on my machine. Let me know if this helps any. Chuck SET NOCOUNT ON CREATE TABLE #TEMP (ALARMID INT NULL, POS INT NULL) CREATE CLUSTERED INDEX...

Hi, Here is what I do to rid of dupes: Create a table with same structure, I do this with select top 1 into temptab from maintable truncate temptab insert into temptab (Customerid) (select distinct customerid from maintable) Update temptab set temptab.field1=maintable.field1...

I loaded a Dfs Root and added shares in this root. I gave both Share rights Full Control to everyone, and NTFS rights of Full Control to everyone in both the root folder I made for the Dfs and for the subfolders. I can see the folders by all PC's 98 and 2000 pro alike, but I cannot write or...

Hi Skine, I just went through some of this last night. When you install ASD to set the Win2k Server as a domain controller it asks for both names to be recognized by the network, (domain.microsoft.com), and then it asks for a domain name for NETBIOS (this is for win9x machines and before (just...

Thank you all for your support, The query I am using is: Update T1 Set T1.Field1 = T2.Field1, T1.Field2 = T2.Field2... From T1, T2 with (nolock) Where T1.IDField = T2.IDField The Updated fields are not indexed and both the IDFields are indexed, on T1 it is nonclustered and on T2 it is...

I have two tables one 17 million records, and the other 10 million records. I am updating fields in the 17 million record db. no matter what kinds of locks or how I break the data down I can only get around 200,000 updates an hour. I have created indexes on the lookup fields. Does anyone...