In S1 I added s2 as linked server. There is no third machine involved.I tried:i) Mixed mode authentication Error: sql doesn't exist or accessd denied.ii) Windows authentication. I checked (radio button) in Linked Server-S2 "Security" tab a) "Be made without using security context" Error: OLE DB Provider reported an error, Invalid authorization b) "Be made using the […]
2004-05-04
Do youo still have the physical files? or those were deleted also? If those exist, just do an attach DB. If the physical files disapeared, I don't see any way you can get that DB back.A sysadmin could have an anser for files deleted and how to restore them afterwards, though. Sorry about that and […]
2004-04-29
Bad database design is the real problem here and not a SQL Server limit. Look into adding audit columns for creation and modification dates.
2004-04-28
Does this program have any GUI components, like msgboxes or similar? xp_cmdshell is for commandline programs only - no GUI (or other interactive parts) will work. /Kenneth
2004-04-28
I have an SQL joining more than 5 tables. The results set contains over 10,000 records. First time the SQL has to fetch only the first 25, then 2ed time with some parameters I should be able to fetch the next 25 and so on How this can be done? Now every time I execute […]
2004-04-27
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/dcorey/bu
2004-04-22
5 reads
Both using 2.7 - however, this would appear more DCOM related - in that it works properly when run on the server, just not locally. The lack of any DCOM errors however is a little surprising.
2004-04-22
In my script, why is it just returning an error: "Invalid column name 'dte'." create table #tmp ( id int, x varchar(50) )insert into #tmp values (1, 'a') insert into #tmp values (2, 'b') insert into #tmp values (3, 'c')select case x when 'a' then '1/1/2000' else '1/2/2000' end AS dte, month(dte), year(dte) from #tmpI […]
2004-04-19
What database are you in when you are trying to run the job? It sounds as if your Query Analyzer is pointing to the database you are trying to restore.
2004-04-15
Try this guy out....not pretty, but might work for you. CREATE PROCEDURE GetRows @Column varchar(25)AS DECLARE @Sql Varchar(50) SET @Sql = 'SELECT ' + @Column + ' FROM Table1' EXEC (@Sql)GO
2004-04-15
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers